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
 
Back
Top