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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
finding average length service

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Finding the average length of service

Finding the average length of service

ResolvedVersion 2003

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.

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

RE: Finding the average length of service

Hi Stephen

The datesin the sheet do refer to start dates.

Thanks,

Paul

RE: Finding the average length of service

Can anyone help?????

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.

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

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

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

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.09 secs.