View Single Post
  #6   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default

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