+ Start a Discussion
mhellarmhellar 

Defining Specific month in Year.

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

hhuiehhuie

Replace YEAR(TODAY()) with

 

DATE(YEAR(TODAY()),9,1)