Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
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.
Re: Birthdate calculation
Posted by Ian on January 23, 2001 10:00 AM
Re: Birthdate calculation
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
Re: Birthdate calculation
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)?
Re: Birthdate calculation
Posted by Joe on January 24, 2001 5:17 AM
That worked great !! Thanks
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.