Date Diff - excluding working days

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?
 
R

Rick Rothstein

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date Formula 0
How to use/create code in MS Word to calculate age? 0
Justification function versus wide spaces 0
Expanding Date formula 2
Subtracting two cell dates and highlight if over due by a certain amount of days 0
How to calculate difference between two date & time along with working hours and days 2
Inconsistent formatting of section numbers 0
Formula to get number of days excluding Fridays in a given period 17

Top