Thread: How to have Excel cells return age (Y/M/D) based upon DOB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default How to have Excel cells return age (Y/M/D) based upon DOB
=DATEDIF(A1,TODAY(),"Y")&" years "&DATEDIF(A1,TODAY(),"YM")&" months
"&DATEDIF(A1,TODAY(),"MD")&" days"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rob Roy" <Rob wrote in message
...
Based upon a date of birth input, can anyone advise how to populate three
cells with a person's age (cell 1 = years, cell 2 = months, cell 3 = days)
using Excel functions?


Reply With QuoteReply With Quote