Calculating no of work days between two dates

F

fluffywhitedoh

Please advise how to calculate the number of work days (excludin
weekeends and holidays) between two date
 
B

Bob Phillips

=NETWORKDAYS(start_date,end_date,holidays)

holidays is a range of holiday dates.

You will need to have the Analysis Toolpak installed, Tools>Addins, and
cheek it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"fluffywhitedoh"
 

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

How to implement two shifts per day with multiple teams 0
number of months and days between two dates without approximation 3
Display weeks from a Milestone 0
Adding days to the WORKDAY function 2
Work Budget Salary vs Real Time Salary 0
Formula within Pivot Table Calculated Field - Days in time period 0
Expanding Date Formula 0
Expanding Date formula 2

Top