If A1 = Start date, B1 = Stop date & C1 = networkdays B1-A1, then what would C1 be if I want C1 to start calculating 1 day past the start date. For example, if my start date(A1) is 06-12-10, C1 starts calculating from 07-12-10 to stop date. So if my start date is 06-12-10 & stop date is 10-12-10, then C1 should reflect 4 days.
In addition to the above, I also have special cases whereby the stop date falls on a weekend day and should reflect in C1. So if my start date is 06-12-10 & stop date is 11-12-10, then C1 should reflect 5 days and not 4 days.
Is it possible to have a formula for the above.
Many thanks in advance!
In addition to the above, I also have special cases whereby the stop date falls on a weekend day and should reflect in C1. So if my start date is 06-12-10 & stop date is 11-12-10, then C1 should reflect 5 days and not 4 days.
Is it possible to have a formula for the above.
Many thanks in advance!