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

Add on 8 working days to a date 2
Week count 2
Workday Formula to include date 0
returning a date 7 business day excluding holidays in the future 2
Formula to get number of days excluding Fridays in a given period 17
Count distinct days from two groups of days 3
Networkdays including Saturday? 5
Date Formulas 7

Top