Dates

Hello Karen,

Hope you enjoyed your Microsoft Excel courses with Best STL.

Thank you for your question regarding which formula can be used for calculating actual working days.

You can use the 'NETWORKDAYS' function for this. To make this work you must enter a start date and an end date. If you have any other days which should not be taken into account such as bank holidays etc. these dates must also be included in the worksheet. The Syntax for this function is as follows:

NETWORKDAYS(start_date,end_date,holidays)

Here's an example:

Date Description
01/10/2008 Start date of project
01/03/2009 End date of project
26/11/2008 Holiday
04/12/2008 Holiday
21/01/2009 Holiday
Formula Description (Result)
=NETWORKDAYS(A2,A3) Number of workdays between the start and end date above (108)
=NETWORKDAYS(A2,A3,A4) Number of workdays between the start and end date above, excluding the first holiday (107)
=NETWORKDAYS(A2,A3,A4:A6) Number of workdays between the start and end date above, excluding every holiday above (105)

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer