Add working days to a date
 

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

Thanks

Add working days to a date
 

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

Add working days to a date
 

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

Add working days to a date
 

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