General discussion

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.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

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

Collapse -

Count Working Days in Excel

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

Poster rated this answer

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
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums