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
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)?
That worked great !! Thanks