skipping weekends/holidays

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

I want to set a suspense date on a control whenever a date is entered in
another control-
suspense would be 30 work days.
Is there a function to use that computes workdays - i.e. doesn't count
weekends and national (US) holidays?
thansk
 
-----Original Message-----
I want to set a suspense date on a control whenever a date is entered in
another control-
suspense would be 30 work days.
Is there a function to use that computes workdays - i.e. doesn't count
weekends and national (US) holidays?
thansk


.
Click to expand...
Hi Junior, have a look at this site for some ideas...

http://www.cpearson.com/excel/holidays.htm

Luck
Jonathan
 
Back
Top