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

Excel

ResolvedVersion 2003

Wed 21 May 2008, 17:09 Delegate Ady said...

Ady has attended:
Excel Advanced course

Excel

I want to calculate no of working days in year by using hire and leaving dates.

Thu 22 May 2008, 15:57 Trainer Simon said...

RE: Excel

Hi Ady,

Thank you for your question.

I have found you the function that will give you the number of working days between the hire and leaving dates.

The first thing you need to do is go to:

Tools - Add-Ins - Tick the Analysis Toolpak and click ok.

By adding this toolpak, you will have access to the NETWORKDAYS function.

So type, =networkdays(A1,B1)

A1 being the cell that contains the from or Hire date and B1 being the cell that contains the To or Leaving date.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Conditional Formatting in Excel 2010