How to exculde saturday and sunday in date calculation?

Hi All,

I have three columns named "name","start_date" and "end_date"

ex:

Name start_date end_date
AB 9/11/13 10:19 AM ??
CD 9/12/13 11:45 AM ??


All i need to find is,

If Name = AB, i want put start_date+3 days in the end_date column,
similarly for name = CD , start_date+7 days.

But the calculation should exculde weekends(sat and sun).

ex:
For AB, start_date = 10/3/13 (3rd oct , thrusday), end_date should be start_date+3 ,so end_date = 10/6/13 but 6th october is sunday so the formula should give end_date as 10/7/13.

I hope this is clear.

Help me to find it .

=NETWORKDAYS(StartDate,EndDate) counts the number of days between dates but ignores weekends.

So if start date is in A1 and end date is in B1, in C1 enter =NETWORKDAYS(A1,B1)

Does that do what you mean?

This is for the 3 day formula above

Please Login or Register  to view this content.

This is for the 7 day formula above

Please Login or Register  to view this content.

Hope this works for you. Good luck