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

[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

 

[Aladin Akyurek]

=NETWORKDAYS(date1,date2,holidays)

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

 

[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

 

[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.

 

[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.