Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Number of Week Days _including_ Holidays
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. |
#2
|
|||
|
|||
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. In article , "Andrew Perry" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert a date into a week number... | Excel Worksheet Functions | |||
Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Convert week number into calendar month? | Excel Worksheet Functions |