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

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
 
D

Deb

Thanks! This worked perfect!!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum to a mid point in a dynamic table 2
HOW TO CALCULATE AGE AS OF A CERTAIN DATE? 2
Calculate age 3
date of birth age formula 8
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Calculate age with an end date 3
Calculating an age at a certain date 4
date of birth or blank cell? 3

Top