If statement based on date

Mary Ayers
Mary Ayers ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to create a formula within my "Academic Year" field so that if the "Date" is more than August 25, 2019, the Academic Year field contents will be "2019-20" -- otherwise, the field contents will be "2018-19".

=IF([Date]1 > (2019, 8, 25), "2019-20", "2018-19"

I am using the date format (2019, 8, 25) based on what I found online for working with dates in Excel. Not sure if that's the same for Smartsheet.

Advice appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!