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"))
Help Article Resources
Check out the Formula Handbook template!