Add working days to 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
 
F

Frank Kabel

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
 
M

Mark Graesser

Jim,
You can use the WORKDAY function.

Good Luck,
Mark Graesser
[email protected]

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