Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate age in term of years, months, days
how do i calculate age in term of years, months, days
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate age in term of years, months, days
put =TODAY() in A1
put your birthday in B1 and put =DATEDIF(B1,A1,"y") & " years, " & DATEDIF(B1,A1,"ym") & " months, " & DATEDIF(B1,A1,"md") & " days" in C1 -- Gary''s Student "shan" wrote: how do i calculate age in term of years, months, days |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
Months or Years remaining, formatting | Excel Discussion (Misc queries) | |||
Formula that will represent years & months worked | Excel Discussion (Misc queries) | |||
Calculate months and years | Excel Discussion (Misc queries) | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) |