That would be less work. Thank you for that one.

"David Biddulph" wrote:

or =IF(DATEDIF(A2,B2,"y")=5,"5 or older","Under 5")
--
David Biddulph

"Sean Timmons" wrote in message
...
so, you have their DOB and another date and want to know if the given date
is
greater than or equal to 5 years from DOB...

Assume DOB is in cell A2 and given date is in B2. In calculated field:

=IF(B2=DATE(YEAR(A2)+5,MONTH(A2),DAY(A2)),"5 or older","Under 5")

"Deb" wrote:

I work at a school and I need to create a spreadsheet which tells me when
a
child reaches the age of 5 on any given date. Can anyone help. Thanks.
Deb