Hello! I’m wondering how to reference a date range in a formula. I’d need to generate estimated grade levels for students by birth date. I would like to format this as a nested IF formula (ex. IF(Birthdate = [DATE RANGE], “Kindergarten”, IF(Birthdate=[DATE RANGE], “1st Grade”, (IF…and so on) - how do I reference a date range in this case?
Thanks for any assistance!