network days

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Network days

Network days

resolvedResolved · Low Priority · Version 2016

Matt has attended:
Excel Intermediate course

Network days

Using network days allows me to discount weekends, but how can I also discount local bank holidays?

RE: Network days

Hi Matt

Thank you for using our forum

When using networkdays, have you set a range of cells somewhere with all the holiday dates listed?

You need to list all the bank holidays somewhere and in the holiday field of the formula dialogue box, select the cell range where you've listed the holiday dates and press F4 to absolute the cell range.

Let me know if that helps

Kind regards
Wendy Canelas
Microsoft Office Trainer

Wed 7 Nov 2018: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips


Server loaded in 0.09 secs.