Exclude Weekends

[rthompson55125]

Hi Excel guru's. I have have to track orders that must be completed within a certain date range, e.g. within 90 days of create date. A simple formula of can address what the expiration date would be, however often these expiration dates land on a weekend.

Simply using a =WORKDAY() is helpful, but not complete due to the expiration landing on a weekend. Any suggestions on how to create an expiration date that considers weekends and subtracts those dates from the expiration date to land it into the nearest business day?

Example: Create Date is 08/11/2015, 90 days later is 11/09/15, but 11/09/15 lands on a Saturday, so I need a formula that accounts for weekends and pushes the date to 11/08/15 which would be a Friday, thus making an expiration date not land on the weekend.

Greatly appreciate your help!!!!!!!!!

 

[Jonmo1]

11/9/2015 is a Monday.
But I get what you're saying anyway...

Try

=WORKDAY(A1+91,-1)

Notice the 91 is 1 more than 90 days, that's intentional.
You could do this to avoid the confusion
=WORKDAY(A1+90+1,-1)

Or if you want to put the 90 in a seperate cell, say B1
=WORKDAY(A1+B1+1,-1)

 

[rthompson55125]

11/9/2015 is a Monday.
But I get what you're saying anyway...

Try

=WORKDAY(A1+91,-1)

Notice the 91 is 1 more than 90 days, that's intentional.
You could do this to avoid the confusion
=WORKDAY(A1+90+1,-1)

Or if you want to put the 90 in a seperate cell, say B1
=WORKDAY(A1+B1+1,-1)

WOW, thank you kindly for your experience and taking the time!!!!

 

[Jonmo1]

You're welcome.