Thread: Age in years only
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jamie Jamie is offline
external usenet poster
  
Posts: 191
Default Age in years only
I need a formula that will just return age in years from a given birthdate. I
have tried using =DATEDIF(A1,TODAY(),"y") but if I do not insert a birthdate
then the formula returns 106
--
Jamie
Reply With QuoteReply With Quote