Thread: How can I test if a date is a workday?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How can I test if a date is a workday?
On 8 Mar 2005 11:59:55 -0800, wrote:

=WORKDAY(A1-1,1,Holidays)=A1

Ron, I love the brilliant simplicity of your solution! Thanks so much.

Nolo

You're welcome. Glad to help.


--ron
Reply With QuoteReply With Quote