I have a workbook that contains a sheet populated from a SharePoint site.
Within this sheet I am attempting to add calculated columns for a pivot table.
This is a simple test formula I have inserted in cells W:
=IF((Y2 > X2), "Inflow","Continued")
The results are in the attached file (with the 3 columns and a few rows copied to a new book).
This formula is returning "Continued" whether the date in column Y is greater than the date in column X.
I am looking for it to return "Inflow" if the date in Y is older than the date in X, and "Continued" if the date in Y is more recent than the date in X.
What am I doing wrong?