Add working days to a date

E

Eán

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

Thanks
 
M

Mike H

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
 
M

Mike H

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
 
J

JE McGimpsey

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 dimensional date sort 1
Number of days in overlapping date ranges (using array formula?) 7
days calculations 6
How to write XIRR formula on excel using different Year basis than 365. 5
Counting number of rows between date range and meeting 2 string criteria 11
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Formula to subtotal monthly expense 5
CALCULATE DAYS PER MONTH BETWEEN 2 DATES 2

Top