View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Tue, 8 Mar 2005 09:39:13 -0800, "Monique"
wrote:

Hello,
I create sheets that are used the next day. I would like to find a way to
calculate tomorrow's date, Monday-Fri, with no holidays included. I haven't
found a way to make it work yet.

i.e:

today()+1 - weekend, holidays

Thank you for your advice!

Monique


Take a look at the WORKDAY function:

=WORKDAY(TODAY(),1,Holidays)




--ron