Calculating Current Age from DOB
I'm very new to Excel, so my question may seem basic.
I am trying to calculate one's current Age by inputting their date of birth. I tried subtracting the two dates, but I get a date and I cannot format that to an age. I would actually like the data in the cell to show the age in years and months (i.e. 3.8 to tell me the age is 3 years and 8 months). Any help is appreciated. Thanks. |
Calculating Current Age from DOB
See Chip Pearson's website:
http://www.cpearson.com/excel/datedif.htm Check the "Calculating A Person's Age" section Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Sonia" wrote: I'm very new to Excel, so my question may seem basic. I am trying to calculate one's current Age by inputting their date of birth. I tried subtracting the two dates, but I get a date and I cannot format that to an age. I would actually like the data in the cell to show the age in years and months (i.e. 3.8 to tell me the age is 3 years and 8 months). Any help is appreciated. Thanks. |
Calculating Current Age from DOB
Try to custom format the difference cell like yy.mm
Regards, Stefi €žSonia€ť ezt Ă*rta: I'm very new to Excel, so my question may seem basic. I am trying to calculate one's current Age by inputting their date of birth. I tried subtracting the two dates, but I get a date and I cannot format that to an age. I would actually like the data in the cell to show the age in years and months (i.e. 3.8 to tell me the age is 3 years and 8 months). Any help is appreciated. Thanks. |
Calculating Current Age from DOB
I work in the insurance industry in the UK - we USUALLY use the
YEARFRAC function for this - this requires that you use the tools menu, add-ins to add-in the Analysis toolpak, but it then makes the return nice and easy - yearfrac gives an exact value, but can be modified to return years and months by multiplying the returned value by 12, taking an integer of it, then dividing back by 12! |
All times are GMT +1. The time now is 07:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com