| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Calc current age of a person
Hi
With birthdate in cell A1 Age in full years =DATEDIF(A1,TODAY(),"Y") Number of full months above age in years =DATEDIF(A1,TODAY(),"YM") Number of days abofe age in years and months =DATEDIF(A1,TODAY(),"MD") -- (Don't use my reply address - it's spam-trap) Arvi Laanemets "RichM" wrote in message ... Need a formula to calc the current age if I have a field with the current date and a field with the birthdate. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
| My calc key on Excel changes box to "Text" Box and doesn't calc ? | Charts and Charting in Excel | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| How do I include the name of the last person who saved a Excel do. | Excel Discussion (Misc queries) | |||
| Excel - Calc current age of a person | Excel Programming | |||
Hybrid Mode
