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 |