How to get # of work days between 2 dates??

L

Les

Hi,

I have looked at the workday and networkdays functions and cant seem to find
the right mix. I need to be able to read 2 dates in cells on a spreadsheet
and report how many just workdays (minus holidays) exists between them.

Thanks
 
A

Aladin Akyurek

=NETWORKDAYS(date1,date2,holidays)

where date1 < date2 and holidays is a range housing the holiday dates.
 
L

Les

Hi and thx for the quick response. Listen I thought that function took care
of the regular holidays automatically or am I mistaken. If so thats what
confuses me with the HOLIDAY parameter.

Thanks
 
A

Aladin Akyurek

You need to create yourself a range of dates that corresponds to the holiday
dates which hold for you. NETWORKDAYS cannot possibly know the holiday dates
in every corner of the world for any given year.
 
N

Norman Harker

Hi Aladin!

Re:
"NETWORKDAYS cannot possibly know the holiday dates in every corner of
the world for any given year."

I'm working on that and hope that I might be able to cover most
countries eventually. The problem is that the various sources are not
particularly comprehensive or accurate.

One difficulty is that with many countries if a given holiday falls on
a Saturday or Sunday then the following Monday is used as a substitute
public holiday. I'll probably end up having to write to embassies /
high commissions for confirmations of dates and algorithms for
replacements.

Another problem though is that many countries also have state or
regional holidays and in some cases there are city or town holidays as
well. Then there's the organization's holidays and of course your own
personal holidays and or religious observances.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 22nd July: Gambia (Liberation Day),
Poland (National Liberation Day), Slovenia (People’s Uprising Day),
Swaziland (Birthday King Sobhuza II)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

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

Date minus work days 8
Formula to tell day of week 3
Calculate next workday after adding calendar days to date in cell 13
How to calculate the number of Workdays for irregular work pattern 1
Calculate workdays for irregular work patterns 1
How do I calculate future date after number of days 1
Workday function returns the wrong date when the duration is 5 day 5
Future date with six day week including holidays 1

Top