workdays calculation

J

jim

Is there an easy function to calculate the number of
workdays between two columns of dates? Need it to
eliminate weekends from count.

Thanks upfront.
 
F

Frank Kabel

Hi
use NETWORKDAYS
note: you may have to install the Analysis Toolpak Add-in for this
 

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

Help using the Workday Function 1
Calculate next workday after adding calendar days to date in cell 13
Calendar Logic: Recurring Dates 3
Add no. of days to a workday to get new workday? 1
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
How to make Friday as weekend instead of Sat/Sun in Workday Functi 11
Calculating new date by entering number of additional workdays 1
Workday function question 2

Top