Excel

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Excel advanced · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · High Priority · Version 2003

Excel

Ady has attended:
Excel Advanced course

by - delegate Ady [3 posts] (2008 May 21 Wed, 17:09) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Excel

by - trainer Simon gold contributer [214 posts] (2008 May 22 Thu, 15:57) Reply

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

· How to Create Better Excel Spreadsheets: Part Four
· Microsoft Excel's Best Kept Secret
· Crazy Things People Have Done With Excel
· Identifying Suitable Candidates For VBA For Excel Training
· How to Create Better Excel Spreadsheets: Part Three

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips

Rate this page: