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

HOW TO CALCULATE AGE AS OF A CERTAIN DATE? 2
Calculate age 3
date of birth age formula 8
Age 5
Calculating age 1
changed DOB to age, but if no DOB need cell to be empty. 4
Calculate a date based on birthdate and future age 4
Calculating an age at a certain date 4

Top