| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculating age in excel
What formula can I use to calculate a person age.
We have the current date on the worksheet as well as a column for the birthdates. Both areas is formatted in a date format. We want a column that will calculate the persons age as of today. Any direction would be greatly appreciated. Em |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculating age in excel
With the DoB in A1 try:
=DATEDIF(A1,TODAY(),"y") -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Emiller" wrote in message ... What formula can I use to calculate a person age. We have the current date on the worksheet as well as a column for the birthdates. Both areas is formatted in a date format. We want a column that will calculate the persons age as of today. Any direction would be greatly appreciated. Em |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| calculating formulas in excel | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
