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

Home » Resources » Forum

working days excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculate working days in Excel?

Calculate working days in Excel?

ResolvedVersion 2003

Tue 16 Sep 2008, 16:49 Delegate Laurence said...

Laurence has attended:
Excel Intermediate course

Calculate working days in Excel?

how do I calculate working days in excel?

Wed 17 Sep 2008, 13:31 Trainer Amanda said...

RE: working days in excel?

Hi Laurence

Thank you for your question.

If you look up NETWORKDAYS in Excel help, this will explain how this function works....basically it will give you the number of working days between two dates (excludes weekends and public holidays in it's count of days).

Amanda

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5 2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back