Formula to check off a box if date is in the past and not blank

deb_63_hydracor · 05/10/22

This is one of the formulas I've tried:

Thanks for your help!

Kevin Smith · 05/11/22

Hi.

This should work for what you have described:

=IF(ISDATE([Date to Deactivate]@row), IF([Date to Deactivate]@row < TODAY(), 1, ""), "")

I hope that helps.

Kevin Smith · 05/11/22

Hi.

This should work for what you have described:

=IF(ISDATE([Date to Deactivate]@row), IF([Date to Deactivate]@row < TODAY(), 1, ""), "")

I hope that helps.

deb_63_hydracor · 05/11/22

It worked. Thank you!

Best Answer