Workdays?

[Guest]

I would like to add days to a start date, that will provide me with an end date. However, I only want to count workdays. So that my due date is always a workday.

Help!

 

[Steve Hartman]

Check out =Networkdays() in the help file.

 

[Aladin Akyurek]

On 2002-03-06 08:33, Anonymous wrote:
I would like to add days to a start date, that will provide me with an end date. However, I only want to count workdays. So that my due date is always a workday.

Help!

=WORKDAY(A1,10)

where A1 houses a start date.

You can even exclude the holidays in determining the due date:

=WORKDAY(A1,10,HOLIDAYS)

where HOLIDAYS is the name of range where holidays are listed.

You need to have activated Analysis Toolpak (via Tools|Add-Ins) in order to use this function.