Help Identifying Weekends and holidays

[craig80]

Hello All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am trying to get a True/False returned in a formula when I reference a date.<o></o>
<o></o>
For example, when a date is on a predefined list/range (and/or) a Saturday or a Sunday. I would like the status to be true<o></o>
<o></o>
<o>Any help would be greatly appreciated.</o>
<o></o>
Thanks

Craig<o> </o>

 

[VoG]

Try

=OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1,ISNUMBER(MATCH(A1,D1:D10,0)))

where D1:D10 holds the holidays.

 

[craig80]

Thats great, works a treat.

I have changed the workday to show workday(A1,2) so as to show keep them the same as the others.

But this is great, thank you vrey much.

Craig