Dates greater than won't work

[mljohn]

I have a report that I have exported as an Excel file (.xlsx) from Insightly.

I am trying to see if the date exported (Col C) is less than or greater than the current date =Today() in (E1). I am using the formula =if(exporteddate(D2)<currentdate($E$1),"less","greater") =if(D2<$E$1,"less","Greater")

The exported date in one cell is 08/12/2019 and the current date is 8/29/2019. That is exactly how they read.
The formula gives me the result of "greater" no matter if the exported date is less than or greater than the current date.

I've tried copy and special paste with values and number formats and that did not work.
I've tried changing the format of the column to date to general to text and still nothing.

What am I missing? How do I fix this?

Thanks

 

[tyija1995]

Hey,

How about:
=IF(C1="","",IF(C1<$E$1,"Less",IF(C1=$E$1,"Equal","Greater")))

 

[mljohn]

Hey,

How about:
=IF(C1="","",IF(C1<$E$1,"Less",IF(C1=$E$1,"Equal","Greater")))

It still says that all the dates are Greater.

 

[mljohn]

Found the solution.
=IF(DATEVALUE(D15)<$E$1,"less","greater")