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!
Bookmarks