Formula Help- Check Box if Date is tomorrow

aelmore

Hi!

I need a formula so that if a date column is the next day, a box is checked. This is what I've started, but I can't figure out how to say- if the date is tomorrow... 

=IF(date:date=????,(1))

Any ideas? Thanks!

Amy

J. Craig Williams

In a checkbox column, this:

=[Date]@row = TODAY(1)

or

=IF([Date]@row = TODAY(1),1,0)

works

I hope this helps.

Craig

Mike Wilday

Hi Amy, One question. Are you wanting that checkbox to remain checked if the date exceeds tomorrow? For example, if I have a row and its checked because tomorrow is the due date. What do you want the checkbox to do when the date = today?  Or what about if it exceeds the date, do you still want it checked?

IF so, you might consider: 

=Date@row <= TODAY(1) 

This will check the date in the row and compare it to today plus a day, and if the date is less then it will remain checked.