How to write something if today's date is between two dates ?



I'm trying to have a box on my dashboard where the harvest season is written. So i need to write a function where Today's date is between two dates. For exemple: If today's date is between 2021/08/01 and 2021/10/30 i want to write "Wine". If the date is between 2021/08/01 and 2021/09/30 i want to write in my box "Cider".

My current function doesn't work :

=IF(Date@row > DATE(2021, 8, 1) AND(Date@row < DATE(2021, 10, 30), "Wine"))

Thank you

Grégoire Cadet

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!