Creating less than today check box

andrew.guirguis61991

I want to create a formula that has a checkbox that will check if the due date column is between today and 7 days. It works but when i format it to the entire column it checks off every because because it considers that if the due date column is blank it's less than today. My formula is:

=IF([Proposed Due Date]@row < TODAY(7), 1)

Please help

J. Craig Williams

You can avoid that in this case by making sure you have "between today and ...", which your formula neglects:

=IF(AND([Proposed Due Date]@row < TODAY(7), [Proposed Due Date]@row >= TODAY()), 1)

If in the future this would not be the case (show me things up to a week away or  in the past) then ISDATE() will help.

Craig