Hi,

I have this formula which assign a students high school level. based on how many years thy have been in school.

CASE(YEAR(TODAY()) - High_School_Start_Date__c,1,"Freshman",2,"Sophmore",3,"Junior",4,"senior","NA")

I'd like to modify it so that it calculates it by September  of the current year instead of today. Does anyone have an idea on how to do that? Thanks in advance.

Best,

Mark