Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Count Working Days in Excel

Locked

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

Topic

Count Working Days in Excel

In reply to Count Working Days in Excel

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

Count Working Days in Excel

In reply to Count Working Days in Excel

Poster rated this answer

Count Working Days in Excel

In reply to Count Working Days in Excel

This question was closed by the author

[Author]

Replies