| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Age Calculation
What is the best way to calculate age as of a certain date (as in age of a
person as of 12/31/2006)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age Calculation
=DATEDIF(DATE(2000,12,25),DATE(2006,12,31),"Y")
"Joan V" wrote: What is the best way to calculate age as of a certain date (as in age of a person as of 12/31/2006)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age Calculation
Joan V wrote: What is the best way to calculate age as of a certain date (as in age of a person as of 12/31/2006)? Hi John, I think that one way would be to use this: =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " & DATEDIF(A1,A2,"md") & " days" Where the date of birth is in A1 and the date is in A2 Regards, Bondi |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age Calculation
I think that will work. Thanks!
"Bondi" wrote: Joan V wrote: What is the best way to calculate age as of a certain date (as in age of a person as of 12/31/2006)? Hi John, I think that one way would be to use this: =DATEDIF(A1,A2,"y") & " years, " & DATEDIF(A1,A2,"ym") & " months, " & DATEDIF(A1,A2,"md") & " days" Where the date of birth is in A1 and the date is in A2 Regards, Bondi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation speed issue | Excel Discussion (Misc queries) | |||
| MOREFUNC.XLL - RECALL() to trigger once only calculation? | Excel Discussion (Misc queries) | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
