Automate checking a box if date column is less than 2 weeks?

brianne111081

I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date.

What would the formula be?

Thank you!

Kelly Drake

= IF([Date Column]@row <= TODAY()+14, 1, 0)

This will leave the box checked as you move forward, so if you do not want dates in the past you want to switch to something more complex:

= IF(AND([Date Column]@row >=TODAY(),[Date Column]@row <=TODAY()+14), 1, 0)

Kelly Drake

= IF([Date Column]@row <= TODAY()+14, 1, 0)

This will leave the box checked as you move forward, so if you do not want dates in the past you want to switch to something more complex:

= IF(AND([Date Column]@row >=TODAY(),[Date Column]@row <=TODAY()+14), 1, 0)