Reverse NETWORKDAYS function?

[gahagan]

Hi:

I know the NETWORKDAYS function will output the NET number of WORKDAYS
between a given start and finish date, skipping a given list of
holidays--but does anyone know if there's a way to input a start date,
a number of days, and a list of holidays, and get the finish date--?

For example, say I wish a task to start on 10/2, and I know it will
take me 10 workdays. How would I find the finish date if, for example,
Friday the 6th is a holiday or day off?

TIA,
AG

 

[Dave Peterson]

=workday()
???

Hi:

I know the NETWORKDAYS function will output the NET number of WORKDAYS
between a given start and finish date, skipping a given list of
holidays--but does anyone know if there's a way to input a start date,
a number of days, and a list of holidays, and get the finish date--?

For example, say I wish a task to start on 10/2, and I know it will
take me 10 workdays. How would I find the finish date if, for example,
Friday the 6th is a holiday or day off?

TIA,
AG

 

[gahagan]

Never mind -- I ended up writing a custom function. Works like a charm!

 

[Tom Ogilvy]

Why reinvent the wheel? Same place that has NetWorkdays has Workday which
does exactly what you describe.

--
Regards,
Tom Ogilvy

Never mind -- I ended up writing a custom function. Works like a charm!

 

[gahagan]

Oh. Thanks, Tom and Dave. I feel like an idiot - my function works
great, but I wasted an hour on it. Now I know...

Why reinvent the wheel? Same place that has NetWorkdays has Workday which
does exactly what you describe.