Date Difference counting only working days

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi,

I know this might be simple but I need to calculate the
difference between two dates, but I need to count the
number of working days i.e. not saturday and sunday
betweeen the two dates.

Cheers

Peter
 
Hi
use NETWORKDAYS. e.g.
=NETWORKDAYS(A1,A2)

Note: You'll have to install the Analysis Toolpak addin to use this function
 
Back
Top