| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Age for date
Hi,
Don't use excel much so please be gentle. Am fairly sure this particular query has been dealt with before but don't have time to sift through thousands of posts. Anyway, have date of birth in one column (E), would like the age to be automatically displayed and updated in another (G). Seemed gobsmackingly simple to start with but haven't been able to get the right formula. Please help! Jim |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Age for date
Assuming that A1 contains the birthday:
=DATEDIF(A1,NOW(),"y") Cheers, JM "Jim Nicholas" wrote in message ... Hi, Don't use excel much so please be gentle. Am fairly sure this particular query has been dealt with before but don't have time to sift through thousands of posts. Anyway, have date of birth in one column (E), would like the age to be automatically displayed and updated in another (G). Seemed gobsmackingly simple to start with but haven't been able to get the right formula. Please help! Jim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Age for date
Hi,
Try this =DATEDIF(E1,TODAY(),"y") Have a look here for an explanation of datedif http://www.cpearson.com/excel/datedif.aspx Mike "Jim Nicholas" wrote: Hi, Don't use excel much so please be gentle. Am fairly sure this particular query has been dealt with before but don't have time to sift through thousands of posts. Anyway, have date of birth in one column (E), would like the age to be automatically displayed and updated in another (G). Seemed gobsmackingly simple to start with but haven't been able to get the right formula. Please help! Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Figuring Vacation Hrs. Earned using Current Date minus Hire Date | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
