Thread
:
Calculating Working Days
View Single Post
#
6
Bernd Plumhoff
Posts: n/a
Other approach (without holidays, calculating from 24:00
of first date to 24:00 of second date):
=(A2-WEEKDAY(A2,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY
(A1,2))+MIN(5,WEEKDAY(A2,2))
HTH,
Bernd
Reply With Quote