Issue with date formulas

Hi!

Fairly new to formulas so forgive me if this is a stupid question

What I'm trying to do is have a cell return a 1 if U3 equals yesterday's date, return a 2 if U3 is more than 1 day greater than yesterday's date, or return a 0 if neither of these are true. I've used the following formula:

=IFERROR(IF(TODAY()-1=INT(U3),1,IF((TODAY()-U3)>1,2),0))

Can attach a sample of the spreadsheet if necessary.

Thanks!

Hi Ali,

U3 is a manually entered date - a target go-live date for a campaign.

Have attached the spreadsheet I'm working on.

Thanks

Try

=IF(TODAY()-1=U3,1,IF(TODAY()-U3>1,2,0))

In W3

=IF(ISNUMBER(U3),IF(TODAY()-1=U3,1,IF(TODAY()-U3>1,2,0)),"")

in X3

=IF(ISNUMBER(W3),IF(OR(AND(W3*1=1,Y3=1,M3=1),AND(W3*1=0,Y3=0,M3=1)),1,IF(AND(W3*1=1,Y3=0,M3=1),2,IF(W3=2,3,0))),"")

Originally Posted by JohnTopley

In W3

=IF(ISNUMBER(U3),IF(TODAY()-1=U3,1,IF(TODAY()-U3>1,2,0)),"")

in X3

=IF(ISNUMBER(W3),IF(OR(AND(W3*1=1,Y3=1,M3=1),AND(W3*1=0,Y3=0,M3=1)),1,IF(AND(W3*1=1,Y3=0,M3=1),2,IF(W3=2,3,0))),"")

This works perfectly! Thank you!