So I have this date on a cell:

E4 = 7/2/2024

But it doesn’t work when I want to compare it with another date.

E6 = E4 > 6/2/2024

Returns FALSE

Surely I can use DATE(), but I need it to work without using any functions since I need to put 2 dates on different cells as a range of time inside a criteria to use DSUM().

I’ve been following a tutorial and this is exactly how they compare dates but it doesn’t work on my PC.

I think it’s a problem with how Excel is interpreting ‘6/2/2024’ but I don’t know how to fix it, I’ve tried with “” , ” () but nothing works, maybe it has to do with some setting configuration.