T
Troy
Sorry for the previous blank post!
Calculation!A1=Date
Calculation!B1:b24= 1:24 (Hours)
Calculation!A25=Date+1
Calculation!B25:B48= 1:24 (hours)
Etc
Data!D12
29 = list of holidays
In Col C on calculations sheet, I am trying to enter a formula that will look at the date and determine Holiday or not. If I fill in the dates for every cell I can use =NOT(ISERROR(MATCH(A4,DATA!$D$12:$D$29,0))), but I would rather not have the date repeating for each hour of the day
How do I do this?
Thanks so much
Troy
Calculation!A1=Date
Calculation!B1:b24= 1:24 (Hours)
Calculation!A25=Date+1
Calculation!B25:B48= 1:24 (hours)
Etc
Data!D12
29 = list of holidaysIn Col C on calculations sheet, I am trying to enter a formula that will look at the date and determine Holiday or not. If I fill in the dates for every cell I can use =NOT(ISERROR(MATCH(A4,DATA!$D$12:$D$29,0))), but I would rather not have the date repeating for each hour of the day
How do I do this?
Thanks so much
Troy