Software

General discussion

Gravatar
0 Votes
Locked

Count Working Days in Excel

By bjjhome.bt ·
Hi All

I have been asked to help one of the staff I support with a problem calulating working days. I dont know if this is podssible except with a huge IF statement. Does anyone know of a way to define and count WORKING days.

Thanks in advance

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Count Working Days in Excel

by DKlippert In reply to Count Working Days in Exc ...

Go to Insert>Function. In the Date & Time category, scroll down to Networkdays. If you don;t see it, go to Tools>Add-Ins and make sure the Analysis ToolPak is checked.
The syntax for Networkdays is:
=NETWORKDAYS(StartDate,EndDate,Holidays)
You can set up a range of Holidays that will be excluded from the count. See the Help file

gravatar
Collapse -

Count Working Days in Excel

by bjjhome.bt In reply to Count Working Days in Exc ...

Poster rated this answer

gravatar
Collapse -

Count Working Days in Excel

by bjjhome.bt In reply to Count Working Days in Exc ...

This question was closed by the author

Back to Software Forum

Start or search

Related Discussions

Related Forums