Finding the average length of service

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

Resolved · High Priority · Version 2003

4 posts

ReplyMon 18 May 2009, 16:26Delegate Paul said...

Paul has attended:
Excel Advanced course

Finding the average length of service

Hi there,

I need to calculate the average length of service within a set of data. In my column U1 to U20, I have dates in the dd/mm/yy format and I need to calculate the average, anyone know any good formulas?

Thanks.

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Mon 2 Aug 2010	Bloomsbury	5		£210	£215	£235
2007	Wed 4 Aug 2010	Limehouse	6		£207	£212	£235
2003	Thu 5 Aug 2010	Limehouse	5		£198	£203	£235
2010	Thu 5 Aug 2010	Bloomsbury	7		£285	£290	£299
2003	Fri 6 Aug 2010	Southwark	0	FULL			£235
2007	Mon 9 Aug 2010	Bloomsbury	6		£207	£212	£235
Full Schedule: See all 163 Excel Intermediate course dates. Bookings currently available until 30th September 2011.

825 posts

ReplyTue 19 May 2009, 13:48Trainer Stephen said...

RE: Finding the average length of service

Hi Paul

Thank you for your question

Can you clarify for me whether the dates in your sheet refer to the date at which people started their service.

Thanks

Stephen

4 posts

ReplyWed 3 Jun 2009, 12:42Delegate Paul said...

RE: Finding the average length of service

Hi Stephen

The datesin the sheet do refer to start dates.

Thanks,

Paul

4 posts

ReplyTue 16 Jun 2009, 16:20Delegate Paul said...

RE: Finding the average length of service

Can anyone help?????

825 posts

ReplyMon 20 Jul 2009, 09:43Trainer Stephen said...

RE: Finding the average length of service

Hi Paul

Thanks for your question

I apologise for the delay in replying. I have been away from work for the last few weeks due to illness. I realise that you may have already solved the problem, if this is not the case could you please advise me so that I can giver it my urgent attention

Regards

Stephen

Mon 27 Jul 2009: Automatically marked as resolved.

· Spreadsheets: What's In A Name?
· Creating Charts with Excel
· How To Link Between Spreadsheets In Excel
· Improving Navigation Of Your Worksheets In Excel
· So Can You Really Sort On Colours In Excel 2007?

Please browse our web site to find out more about
excel training microsoft and other Microsoft training courses.

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips