View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nicky Nicky is offline
external usenet poster
 
Posts: 15
Default 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!