Difference between two dates formula help

[Flora2021]

Hi, I have a spreadsheet where I need to indicate if the date in column H is 3 days n the date in column J.


So the Order Date in in column J – let’s say an order was created 7/31 - in column H if the date has dates within 3 days after the order date in column J we want to count. In this case it should show "yes" if the date in column H is 7/31, 8/01, 8/02, or 8/03.

 

[AhoyNC]

Like this?

Book2
	H	I	J
1		Within 3 days	Order Date
2	8/2/2023	Yes	7/31/2023
3	8/1/2023	No	7/25/2023
Sheet1

Cell Formulas
Range	Formula
I2:I3	I2	=IF(OR(H2<J2,H2-J2>3),"No","Yes")