Calculating Age NOT as of today but as of a date in the future or

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

I often need to calculate student age as of a specific date.
For example:
A1: DOB
A2: age as of Sept 30, 2010

I need a formula that will also work if I need to choose a date in the past
too, such as: age as of Sept 30, 2007

Thanks in advance for your help.
 
One way could be:
=IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y"))
Micky
 
Thanks! This worked perfect!!

מיכ×ל (מיקי) ×בידן said:
One way could be:
=IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y"))
Micky
Click to expand...
 
Back
Top