I have a cell with an "end date" and I have a checkbox under an "Inactive" labelled column. I would like that checkbox to turn on when today's date is after the end date.

I can't seem to add a formula of the checkbox cell without breaking it. So I have tried to a formula in the cell beside it saying:

=IF (E5 < TODAY(), G5=1, G5=2)

where E5 is the "end date" cell and G5 is the checkbox.

It's not working. What am I doing wrong?

1 Answer 1


=IF(E5 < TODAY(), 0, 1)


demo spreadsheet

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.