Automate checking a box if date column is less than 2 weeks?
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!
Best Answer
-
= 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 (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Answers
-
= 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 (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Help Article Resources
Categories
Check out the Formula Handbook template!