MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Birthdate calculation


Posted by Joe on January 23, 2001 9:01 AM

I need to calculate an age compared to a fixed date of 7/31/2001.


Posted by Ian on January 23, 2001 10:00 AM

Check out 7583.html


Posted by Joe on January 23, 2001 10:23 AM

Thanks for the reply. I did look at that calculation, however,
that calc only gives the year. What I am looking for is a calculation
that can classify an age group based on 7/31/2001.
For example: a birthday is 9/7/89, based on the
7/31/2001 date, the year group would be 11. Any
birthdate during 1989 from July back to January
would be grouped as a 12.

Thanks
Joe

Posted by Ian on January 23, 2001 11:35 AM

This should work if you substitute your date for the today() value. How about =DATEDIF(A1,A2,"y"), where A1 is the birthday and A2 is your constant (7/31/01)?

Posted by Joe on January 24, 2001 5:17 AM

That worked great !! Thanks