Hi...

I'm trying to use an IF(OR formula to test whether 1 date/time stamp is within 24 hours before or after another.

cell B2: 7/23/13 13:00 (cell formatted this way for time)
cell D2: 7/25/13 07:00 (cell formatted this way for time)

=IF(D2="","",IF(OR(B2=D2+1,B2=D2-1),"YES","NO")) - which isn't working for me

thanks!