Hi
Is there anyway I can add working days to a date?
For example:
23-Feb-09 + 10 = 06-Mar-09

Thanks

Hi,

Try this

=workday(A1,10,Holidays)

The last argument 'Holidays' is an optional named range that includes the
dates of any holidays you want included in the calculation.

Mike

"Eán" wrote:

> Hi
> Is there anyway I can add working days to a date?
> For example:
> 23-Feb-09 + 10 = 06-Mar-09
>
> Thanks

I forgot to mention,

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Tools|Addins

Mike


"Mike H" wrote:

> Hi,
>
> Try this
>
> =workday(A1,10,Holidays)
>
> The last argument 'Holidays' is an optional named range that includes the
> dates of any holidays you want included in the calculation.
>
> Mike
>
> "Eán" wrote:
>
> > Hi
> > Is there anyway I can add working days to a date?
> > For example:
> > 23-Feb-09 + 10 = 06-Mar-09
> >
> > Thanks

Perhaps you better explain what you mean by "working days".

23 Feb 09 -> 6 Mar 09

is a span of 11 TOTAL days. Which day isn't worked?

If you mean to exclude Saturdays and Sundays:

A1: 23 Feb 09
A2: =WORKDAY(A1,10)

will return 9 Mar 09 in A2.



In article <FA7E7054-E178-4BC5-A85F-(E-Mail Removed)>,
Eán <(E-Mail Removed)> wrote:

> Hi
> Is there anyway I can add working days to a date?
> For example:
> 23-Feb-09 + 10 = 06-Mar-09
>
> Thanks