Forum Discussion
Date
I want to calculate someone's age using their DOB and current time and date. =(YEAR(NOW())-YEAR(C150)) this formula does not take into account the current time or day. 23/11/2013 is returning age...
You can use the undocumented DATEDIF function to calculate age in years/months etc. To display just age in years, you could use:
=DATEDIF(A1,TODAY(),"y")
To display the age in years, months and days, you could use something like:
=IF(DATEDIF(A1,TODAY(),"y")<>0,DATEDIF(A1,TODAY(),"y")&" years ","")&IF(DATEDIF(A1,TODAY(),"ym")<>0,DATEDIF(A1,TODAY(),"ym")&" months ","")&IF(DATEDIF(A1,TODAY(),"md")<>0,DATEDIF(A1,TODAY(),"md")&" days","")
Hope that helped.