Thread
:
NETWORKDAYS
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
NETWORKDAYS
If you have 3 holidays to exclude you need to enter each holiday date in a
separate cell:
H3 = some date
H4 = some date
H5 = some date
Then:
=NETWORKDAYS(F3;G3;H3:H5)
--
Biff
Microsoft Excel MVP
"La Siesta" <La
wrote in message
...
All,
I'm trying to use the function NETWORKDAYS:
=NETWORKDAYS(F3;G3;H3)
F3 = 1-04-2009
G3 = 30-04-2009
H3 = 3 holidays
Date format starts with an asterisk to respond in regional date settings.
I tried everything, but still not working. What do I miss.
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko