IF-formula on a date range

Options

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,


Jordi


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!