Excel - Display working day only

Hello Kuniko,

Hope you enjoyed your Microsoft Excel courses with Best STL.

Thank you for your question regarding using a function to display working days only.

You can use the function NETWORKDAYS to do this.

NETWORKDAYS requires a start date, end date and excluded dates such as bank holidays etc. The last item is optional.

Setup Excel by inserting a start date in one cell and an end date below that. Then if you wish to include bank holidays as exceptions then list each bank holiday below the end date. The formula would look something like this:

=NETWORKDAYS (A1,A2,A3:A7)

A1 is the cell containing the start date
A2 contains the end date
A3:A7 contains 5 bank holiday dates.

Test this on a short period to convince yourself that it works and then you can try it on longer periods of time.

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