Calculating difference between dates
Wtih start date in A1 and end date in B1; try the below which will give you
the count inclusive of both dates (excluding Sat and Sun)
=(B1-WEEKDAY(B1,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY(A1,2))+MIN(5,WEEKDAY(B1,2))+1
If this post helps click Yes
---------------
Jacob Skaria
"DUNNER7" wrote:
I have column c with the start date ex. 9/4/2009 and column d leave date ex.
11/02/09. How can I calculate number of school days (no SAT and SUN) that
the student attended between these two dates in column e?
Thanks
Del Dobbs
|