Thread: calculate Age Year Month & day
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
  
Posts: 793
Default calculate Age Year Month & day
Try =DATEDIF(BirthDate,TODAY(),"y")&" years
"&DATEDIF(BirthDate,TODAY(),"ym")&" months
"&DATEDIF(BirthDate,TODAY(),"md")&" days"

For details and source of this go to
http://www.cpearson.com/excel/datedif.aspx

"shailendra joshi" wrote:

my bdate 14-10-1979
to day 06-09-2008

to day my age is 28 year 10 month & 23 days
how to calculate in excal 2007 this formate
Reply With QuoteReply With Quote