Google Sheets Compare One Date to Another Date + 1 or 2 Days

user_16931748 0
Viewed 42

I'm having trouble with this formula - which I feel should be easy but I'm not figuring it out.

I have a column with a request submission date and time and a column with an edit date and time. I'm looking at how many requests were edited exactly one day after it was submitted and another statistic one how many requests were submitted at least 2 days after submission. I think my issue is coming when I do the +1 or +2 to the date in the formula.

Please take a look of a sample of what I'm doing here...I'll also include a screenshot of the sheet below.

enter image description here

Thank you for any assistance.

google-sheets if-statement timestamp date datetime
1 Answers

try:

=INDEX(IF(B2:B="",,{
 IF(INT(B2:B)>=INT(A2:A), "Y", "N"), 
 IF(DAYS(INT(B2:B), INT(A2:A))>=1, "Y", "N"), 
 IF(DAYS(INT(B2:B), INT(A2:A))>=2, "Y", "N")}))

enter image description here

user_56326290
Related