How can I test if a date is a workday?
Nolo,
Assuming date in E1, and the holidays in named range called holidays
=AND(WEEKDAY(E1,2)<5,COUNTIF(holidays,E1)=0)
--
HTH
RP
(remove nothere from the email address if mailing direct)
wrote in message
oups.com...
I need to test whether a date entered by the user is a workday, so I
can use the "true" or "false" returned by the test in another formula
in the spreadsheet. I have a cell range of holidays set up. The date
entered by the user could be any date in the year and any day of the
week.
Thanks,
Nolo
|