Thread: [Solved] Calculating age at date
View Single Post
 
Old 02-21-2011, 07:45 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
Hi

The exact formula will depend on how you want the age reported.

In years? Like this:
Code:
=DATEDIF(A2,B2,"y")&" years"
In years and months? Like this:
Code:
=DATEDIF(A2,B2,"y")&" years " & DATEDIF(A2,B2,"ym") &" months"

etc...
Reply With Quote