Adding dayys to a date without adding weekends

10 pts.
Tags:
Calendar
Excel formulas
Microsoft Excel
I want to enter a date into a cell in microsoft excel and in another cell I want it to add five days onto the previous date without includind the weekends in so if I enter the 7/16/2008 into the first cell then I want to have it add five work days making it the 7/23/2008 instead of five regular days wich would be 7/21/2008

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is no day of the business week (Mon-Fri) that when adding 5 days avoids hitting weekend days, so just add 7. This assumes that you are not allowed to begin on a weekend day (Sat-Sun), and that you don’t care about international dates (where they are a day ahead or behind).

Yes, adding 7 is a good solution. Another option may be to interrogate the day by Weekday function. Then add 1 or 2 days if it is on Sat or Sunday. This forces Sat or Sunday to next Monday. Hope it helps.

Example: Format cells B2, C2, and E2 as Date. B2 as 7/13/2008; C2 =B2+7;D2 =Weekday(C2); E2 as =IF(D2=1,C2 +1,IF(D2 =7, C2 +2,C2))

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following