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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automating Suspenses 1
Calculate next workday after adding calendar days to date in cell 13
WORKDAY and holidays 7
Date Calculation Formula- Calendar days minus Holidays 1
Help with determining deadlines 8
Conditional formatting excluding weekends and holidays 1
Problems with MS Access reading dates as US, not British formats. 2
skip holidays and weekends 1

Back
Top