View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected][_2_] debbiep@ywcaofjamestown.com[_2_] is offline
external usenet poster
 
Posts: 6
Default IF 5 years old by Dec 1 they will start Kindergarten

I am looking for help to determine a formula that will let me
determine which children who will be 5 years old by Dec 1, 2007.

Col
A [FirstName]
B [LastName]
C [DOB]
D [Classroom] (Kool Kidz, Kinder-Ready
If they are 5 in Dec, their classroom will default to KOOL KIDZ;
otherwise, they will be KINDER-READY
Can any one help me with this formula.

Thank you in advance.