Data being exported into my excel sheet is all text.
When formatting columns P & R to Date format, I selected the 3/14/2001 option
In cell C1 I entered the date 1/8/2019
In cell C2 (first row of data in columns P & R) i entered IF(ISBLANK(P2),"",IF($C$1>P2,"Get Update","OK")) and copied / pasted into all rows of data in P.
All results show OK even when they should say Get Updated
Note - got the same result in a column I had formatted as Date and in a column formatted General.
How do I get the dates to compare??
Thank you very much!
Bookmarks