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

=workday()
???

wrote:

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

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

Dave Peterson wrote:
=workday()
???

wrote:

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

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

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
Never mind -- I ended up writing a custom function. Works like a charm!

Dave Peterson wrote:
=workday()
???

wrote:

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

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

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

--
Regards,
Tom Ogilvy

wrote in message
ups.com...
Never mind -- I ended up writing a custom function. Works like a charm!

Dave Peterson wrote:
=workday()
???

wrote:

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