Can Excel add working days to a date to result in another date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example, I need Excel to take the last day of a quarter (6/30) and add 10
working days resulting in the date of the 10th working day.
 
Use the WORKDAY function. These examples are from the Excel 97 help
entry for WORKDAY:

WORKDAY(DATEVALUE("01/03/91"), 5) equals 33248 or 01/10/91

If January 7, 1991 and January 8, 1991 are holidays, then:
WORKDAY(DATEVALUE("01/03/91"), 5, {33245, 33246}) equals 33252
or 01/14/91
 
You must log in or register to reply here.

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

Workday Formula to include date 0
If statements?? 2
I need Help with a date calculator 0
Adding days to a date - changed in Excel 2010 8
formulas to count dates 2
Days between dates including start day and weekends 7
Finding available payment date 5
Date formula 4

Back
Top