Number of Week Days _including_ Holidays

  • Thread starter Thread starter Andrew Perry
  • Start date Start date
A

Andrew Perry

I was wondering if anyone can help me: I've been trying to figure out how I
can get Excel to calculate the number of weekdays between two dates (in a
similar method to NETWORKDAYS) but to also include any public holidays (as
they're not included in our holiday allowance). Does anyone know of a way of
doing this? It seems a pain to find a list of the public holidays for the
coming year and then entering them into a list that needs to be updated.

Thanks in advance.

--
Regards,

-Andrew Perry (Network & Servers Officer),
Computer Office, Trinity College, Cambridge
University.
 
Given that "public holidays" vary from country to country, state to
state, region to region, even company to company, etc., I'm not sure
what general solution would work, other than generating such a list for
use in NETWORKDAYS.

Microsoft Entourage (Mac) comes with a plain text list of holidays for
76 countries, but the US holidays include Administrative Professionals
Day, Groundhog Day, Halloween, etc., and only through 2007 or 2011,
depending on country. Don't know if Outlook has something similar.
 
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

Networkday & workday with array functions 1
Alternative formula to exclude holiday calculation 6
6 day/week function ie:networkday 6
Calculate the number of days to exclude Sunday & Holidays 6
Future date with six day week including holidays 1
Can't get NETWORKDAYS to calc elapsed banking days in a month 2
How to get Holidays in cell/s? (Find explaination in details) 3
Formula Workdays-Holidays-adjustments 4

Back
Top