I am trying to make an If and then formula to check a box

twheeler

I am trying to make an if and then formula. I have one cell that is a checkbox (SEO) and another is a date (SEO date). What I need is for the formula to check a box (SEO CHECK complete) when (SEO) is true and (SEO Date) is +1day.

It is mainly the formatting on the Time that has me confused.

Any help is greatly appreciated

Kimberly Loveless

@twheeler I just want to clarify before I try to get you a formula what do you mean by +1day? I have some ideas and it should be easy but I want to make sure that the date part is set right

twheeler

On day after the date in the (SEO Date)

Kimberly Loveless

you could try...

=IF(AND(SEO@row=1, TODAY()>=[SEO Date]@row+1),1,0

This will allow it to check if it is the SEO Date +1 day or more, otherwise the SEO Date +2 days for example won't show. If however you only want it checked on that one day then you would use this one...

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

twheeler

Perfect! Thanks. That worked.