IF-formula on a date range


Hi guys,

For the last couple of days I've been trying to create a simple formula, but in some way it doesn't work.

I want to check if the date of today falls inbetween a specific date range (2 different columns), using the IF-formula.

I've tried this formulas:

=IF(AND([Date 1]1>=TODAY(),[Date 2]1<=TODAY), "True", "False")

=IF(AND([Date 1]1>TODAY(),[Date 2]1<TODAY), "True", "False")

But it doesn't appear to be working.

Would be nice to hear from you,



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!