Is there a way to calculate business working days between dates i.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 dates and need to find out how many actual working days there is
between them. I need to subtract weekends and holidays.

This cannot be an estimate. Due to governmental requirements, it must be
acurate.
 
You nee the NETWORKDAYS function. This needs the Analysis Toolpak to be
installed.

It takes the form

=NETYWORKDAYS(start_date,end_date,holiday_array)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Calculate minutes between dates based on 9hr work days 1
Date Calculation problem 3
Calculate days help 2
Date Calculation Formula- Calendar days minus Holidays 1
UK Business Days Formula 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculate next workday after adding calendar days to date in cell 13
Date calculation help please! 7

Back
Top