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
|