Skipping weekends when calculating a due date

  • Thread starter Thread starter Cheyne Burns
  • Start date Start date
C

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
 
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
Click to expand...

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
 
Back
Top