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

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.

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

One way could be:
=IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y"))
Micky


"Deb" wrote:

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.

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

http://www.cpearson.com/excel/datedif.aspx
--
HTH...

Jim Thomlinson


"מיכאל (מיקי) אבידן" wrote:

One way could be:
=IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y"))
Micky


"Deb" wrote:

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.

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

Thanks! This worked perfect!!

"מיכאל (מיקי) אבידן" wrote:

One way could be:
=IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y"))
Micky


"Deb" wrote:

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.