Compare two date columns and record entry in third column

[Bullflip]

Hi,

I know there is a way to record an entry in excel after comparing two date columns. Unfortunately, it's a Monday and my brain is not functioning at the moment. Can anyone please assist? In the screenshot below, I want to compare column L to column J and find out whether or not the work order was closed the same day. The logic I'm looking for is: If L2 > J2, then M2 = "No" else "Yes". Any help would be greatly appreciated. Thanks!

 

[alz]

Try This! in M2 and drag down
=If(L2=J2,"Yes","No")

 

[Toadstool]

Hi Bullflip,

The thing to be careful of is that formatting isn't hiding a time of day which would fail the comparison.

This works if no times are held or both hold times.

Bullflip.xlsx
	J	K	L	M
1	WO Created		WO Closed	Closed same day?
2	1/10/2020		01/10/20	Yes
3	1/10/2020		01/10/20	Yes
4	1/10/2020		01/10/20	Yes
5	1/10/2020		01/12/20	No
6	1/10/2020		01/10/20	Yes
7	1/11/2020		01/10/20	Yes
8	1/12/2020		01/13/20	No
9	1/12/2020		01/12/20	Yes
Sheet1

Cell Formulas
Range	Formula
M2:M9	M2	=IF(L2>J2,"No","Yes")

 

[Bullflip]

Thank you both for the suggestions!