| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 42096 | 2004-01-31 23:40:00 | Excel | Jakkie (1395) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 211960 | 2004-01-31 23:40:00 | 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? | Jakkie (1395) | ||
| 211961 | 2004-02-01 00:12:00 | 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. |
godfather (25) | ||
| 211962 | 2004-02-01 00:14:00 | Hi Jakkie, see this site (www.cpearson.com) and look for the heading 'Calculating A Person's Age' (about halfway down). | parry (27) | ||
| 211963 | 2004-02-01 00:18:00 | 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. |
robo (205) | ||
| 211964 | 2004-02-01 00:19:00 | Holy crap! There were no answers when I started replying to this. robo. |
robo (205) | ||
| 211965 | 2004-02-01 00:30:00 | 6 mins slower than GF. As you are an accountant by trade is that extra 6 minutes chargable :D | Dolby Digital (160) | ||
| 211966 | 2004-02-01 00:30:00 | Thanks Godfather and Parry for your quick reply. The website that you recommended Parry, is excellent. Jakkie |
Jakkie (1395) | ||
| 211967 | 2004-02-01 00:41:00 | Thanks Robo. This sound much easier. There is hope for me!! | Jakkie (1395) | ||
| 211968 | 2004-02-01 03:17:00 | 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. |
robo (205) | ||
| 211969 | 2004-02-01 04:45:00 | > Thanks Godfather and Parry for your quick reply. The > 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. (www.cpearson.com) |
parry (27) | ||
| 1 | |||||