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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » NETWORKDAYS

NETWORKDAYS

ResolvedVersion Standard

Thu 20 Mar 2008, 11:31 Delegate Simon said...

Simon has attended:
Excel Introduction course

NETWORKDAYS

I have created a formula using Excel 2003 that counts the number of days between 2 dates. However, although Excel has given a figure removing the weekends as required, it has not taken into account the Bank Holidays like the help file said it would.

How can I change the formaula to ensure that the Bank Holidays are taken in account?

Thu 27 Mar 2008, 16:43 Trainer Rajeev said...

RE: NETWORKDAYS

Dear Simon

Thank you for attending Excel Introduction course. I hope that you enjoyed the course and benefited from it.

Unfortunately Excel has been programmed to exclude only the Weekends from the week when calculating the NETWORKDAYS function. You

Attached files...

NETWORKDAYS Function.xls

Fri 28 Mar 2008, 10:37 Delegate Simon said...

RE: NETWORKDAYS

Brilliant - thanks!!

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips