View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nolonemo@yahoo.com is offline
external usenet poster
 
Posts: 2
Default How can I test if a date is a workday?

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