If statement based on date

Mary Ayers

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!

Mike Wilday

Try this... 

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

Mary Ayers

Perfect!! Thanks so much!

Mary

Mike Wilday

You're welcome!