Network Days

[gpouliot]

I am trying to figure out how to keep a visit whithin a work week.

Example:

Account Visit: 08/09/2011
We want to revisit the account in 60 days

So I did =F2+60 which gives me a date of 10/08/2011. Only problem is the date falls under a Saturday. So I would want to keep it in a work week?

Any ideas how I could do this?

Thanks

 

[Derek Brown]

Have a look at the WORKDAY function.
You can also provide a list of holidays to be excluded.

 

[Jonmo1]

If it does fall on a weekend, what do you want to happen?
Return the following Monday, or previous Friday?

To return the following Monday, use
=WORKDAY(F2+60-1,1)

To return the previous Friday, use
=WORKDAY(F2+60+1,-1)


As Derek said, this can also exclude Holidays.
Put a list of holidays in say A1:A20

=WORKDAY(F2+60+1,-1,$A$1:$A$20)


The workday function requires the Analysis toolpack from Tools - Addins.


Hope that helps.