Date Difference
hi
="My Age now is "&DATEDIF(A1,TODAY(),"y")&" Years,
"&DATEDIF(A1,TODAY(),"ym")&" Months and "&DATEDIF(A1,TODAY(),"md")&" Days"
the above formula is all 1 line.
Regards
FSt1
"Maanu" wrote:
Hi,
My DOB is 2-Feb-1970.. I want to know my age on 1-Jan-2010 in Years,Months
and days for Eg: 10 Years,9 months and 10 days.
How can I do this in Excel?
I took the difference by putting the two dates in two cells and took the
difference. But it is not working,
Thanks!
|