| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating monthly totals for current and previous year | New Users to Excel | |||
| extract date from the most current date | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Calculating current age from 2 date cells | Excel Worksheet Functions | |||
Threaded Mode
