Holidays in a Lookup

[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

 

[Jason Morin]

Add COUNTIF(myrng,B77) within your OR section,
where "myrng" contains the list of holidays:

=IF(OR(---,---,COUNTIF(myrng,B77)),,27)

HTH
Jason
Atlanta, GA

 

[Brenda Hutton]

Thanks. I'll pass this along to the user.

Add COUNTIF(myrng,B77) within your OR section,
where "myrng" contains the list of holidays:

=IF(OR(---,---,COUNTIF(myrng,B77)),,27)

HTH
Jason
Atlanta, GA