1. ## Excel

Can anyone help me? I am working in Excel. I have 35 birthdates of students. I want to work out what is their age e.g. date tested: 2004-10-28 and a birthdate e.g. 1992-03-28. On paper I can deduct their birthday from 2004-01-28, but it take ages to do. Is their a shorter method to do this in Excel?

2. ## Re: Excel

Just perform arithmetic on the dates in excel.

2004/10/28 - 1992/03/28 = 4597 (days)

Divide the days by 365.25 to get years (12.59)

You need to format the calculated cell as a number, it will assume a date format and give a strange answer until you do.

3. ## Re: Excel

Hi Jakkie, see this site and look for the heading 'Calculating A Person's Age' (about halfway down).

4. ## Re: Excel

Easy. If today's date is in B1 and their birth date is in A1:

=(B1-A1)/365.25

Make sure you format the cell as a number (choose Format, Cells, and choose number. If you have two decimal places you will get an answer like 5.85.

This formula:

=INT((B1-A1)/365.25)& "years and "&((B1-A1)-INT((B1-A1)/365.25)*365.25)&"days"

Says "6 years and 278 days" if you want to get really carried away.
(I would copy this and paste it in to try it out)
Good luck, teach.
robo.

5. ## Re: Excel

Holy crap! There were no answers when I started replying to this.
robo.

6. ## Re: Excel

6 mins slower than GF. As you are an accountant by trade is that extra 6 minutes chargable

7. ## Excel

Thanks Godfather and Parry for your quick reply. The website that you recommended Parry, is excellent.

Jakkie

8. ## Re: Excel

Thanks Robo. This sound much easier. There is hope for me!!

9. ## Re: Excel

Never turn down a chance to charge someone.

Hear the one about the accountant that died? He got to the Pearly Gates and there were ticker-tape parades, brass bands, God personally welcomed him. He asked if they made this fuss for everyone and God said "You're the oldest person we've had". The Accountant said "But I'm only 56.". God says "That's odd, we added up the time you've done on your timesheets and we figured you were 126!"

Sorry.
robo.

10. ## Re: Excel

> website that you recommended Parry, is excellent.
>
> Jakkie

Nothing wrong with Godfathers and Robo's advice either, just shows theres usually more than one way to do things. :-)

Chip Pearson is an Excel MSVP with a lot of good tips and I recommend bookmarking this page.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•