B
Brenda Hutton
Does anyone know how to account for Holidays in a lookup table when already
using OR logic to account for weekends?
I have a formula in an Excel file to populate the number of bank accounts
(27) that we verify imports daily. I need to exclude weekends and holidays.
I can handle the weekends by using an OR with WEEKDAY function. Returns 0
on weekends - anyway to have blank?
C77=
IF(OR(WEEKDAY(B77,1)=1,WEEKDAY(B77,1)=7),,27)
B77 = 09/07/2004
How can I handle the holidays like 09/06/2004?
01/01/2004
01/19/2004
02/16/2004
05/31/2004
07/05/2004
09/06/2004
10/11/2004
11/11/2004
11/25/2004
11/26/2004
12/23/2004
12/24/2004
12/30/2004
12/31/2004
using OR logic to account for weekends?
I have a formula in an Excel file to populate the number of bank accounts
(27) that we verify imports daily. I need to exclude weekends and holidays.
I can handle the weekends by using an OR with WEEKDAY function. Returns 0
on weekends - anyway to have blank?
C77=
IF(OR(WEEKDAY(B77,1)=1,WEEKDAY(B77,1)=7),,27)
B77 = 09/07/2004
How can I handle the holidays like 09/06/2004?
01/01/2004
01/19/2004
02/16/2004
05/31/2004
07/05/2004
09/06/2004
10/11/2004
11/11/2004
11/25/2004
11/26/2004
12/23/2004
12/24/2004
12/30/2004
12/31/2004