Skipping weekends when calculating a due date

[Cheyne Burns]

Howdy,

I am contstructing a worksheet for a mail merge and am
having a spot of trouble.

I have a SentDate field and a DueDate field. I would like
to add two weeks (from a weekday) and if it lands on a
weekend (Saturday, Sunday) to add extra to make sure it is
due on a weekday.

I am not fussed about public holidays and normal holidays.

Most appreciated if someone could help.

Thanks,
Cheyne

 

[keepitcool]

activate analysis toolpak addin.
then have a look at networkdays function.

keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Ron Rosenfeld]

Howdy,

I am contstructing a worksheet for a mail merge and am
having a spot of trouble.

I have a SentDate field and a DueDate field. I would like
to add two weeks (from a weekday) and if it lands on a
weekend (Saturday, Sunday) to add extra to make sure it is
due on a weekday.

I am not fussed about public holidays and normal holidays.

Most appreciated if someone could help.

Thanks,
Cheyne

If you add two weeks (from a weekday), and two weeks = 14 days, there is no way
that DueDate can be a weekend day.

Dates are stored in Excel as a number representing the number of days since a
base date (1/1/1900 or 1/1/1904).

So DueDate = SentDate + 14


--ron