Date Diff - excluding working days

  • Thread starter Thread starter Scott_goddard
  • Start date Start date
S

Scott_goddard

Hi all, Does anyone know how i can return the difference between two dates
that across weeks, months and years and only count working days?
 
You will want to use the NETWORKDAYS function... if you are using XL2007 or
later, this function is built into Excel... if you are using XL2003 or
earlier, you need to activate the Analysis ToolPak add-in (Click
Tools/Add-Ins on the Excel menu bar).
 
Back
Top