Software

Ask something
Discussion Locked

Count Working Days in Excel

0 helpful
3 replies

by bjjhome.bt

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by dklippert

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

This discussion is closed to new replies.