Days between 2 dates
Unfortunately neither of them have worked.
"Mike" wrote:
or a bit less detailed
=DATEDIF(A2,A1,"Y")&" Years old"
"Nicky" wrote:
I want to find out how old a person is.
A1 is todays date 2007/2/22 and A2 is their birthday 1975/04/22.Both cells
are in date format.I say A1-A2 the answer appears as a date and when I change
it to a number I get 11629 which is WRONG. It should equal 31.
Pls help!
|