NETWORKDAYS

L

La Siesta

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

T. Valko

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)
 

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

Top