Formula that returns true/false if today's date falls between two dates on my sheet?

I am trying to write a formula that returns true/false when today's date falls between a date range on my sheet. I want the formula to return "true" if today's date falls between "Start Date" and "End Date."

Below is my current formula, but I continue get a returned value of "#DATE EXPECTED."

=IF(AND(TODAY() >= [Start Date]1, TODAY() <= [End Date]1), true, false)

Any suggestions you have as to how I can make this formula work would be helpful. Thank you!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!