Add working days to date...

  • Thread starter Thread starter jim
  • Start date Start date
J

jim

Hi all,
I would like to be able to add a number of working days to
a given date to determine the 'due-by' date. Any ideas how
I might do this. The formulae would need to accommodate a
list of public holidays in the way the NETWORKDAYS
function does. Any hideas greatly appreciated.
Cheers!
jim
 
Hi Jim
use the WORKDAY function:
=WORKDAY(A1,add_number_of_days,holidays_rng)
where A1 is your starting date and holidays_rng a list of your
holidays.

HTH
Frank
 
Jim,
You can use the WORKDAY function.

Good Luck,
Mark Graesser
(e-mail address removed)

----- jim wrote: -----

Hi all,
I would like to be able to add a number of working days to
a given date to determine the 'due-by' date. Any ideas how
I might do this. The formulae would need to accommodate a
list of public holidays in the way the NETWORKDAYS
function does. Any hideas greatly appreciated.
Cheers!
jim
 
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

Number of working days between 2 dates 1
Subtracting Holidays from Calendar Days 4
converting working hours to days 2
Sumproduct with added days 2
Count specific days in between dates 2
Formula for finding Date difference between 2 dates 4
Count Number of Days after a Start Date 4
Working Days function copied down column 1

Back
Top