How to calculation no. of days (only working days) between two dat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two date in date format, when I minus the two I can get the no. of
days. Any solution to exclude sat and sun, so only working days is counted?
 
Hi,

Check out networkdays

=NETWORKDAYS(A1,B1)

Where A1 is the earlier date. The formula can also take a 3rd argument for
holidays so look at help.

Mike
 
Back
Top