text filters vs date filters

[Artboy34]

I have two Excel workbooks, one being a clone of the other, and each having multiple columns in which dates are populated by formulas. In my original workbook, I am able to filter each column using date filters (next month, this month, etc.), but in the second workbook, the only filter option is a text filter. The formulas are the same, and the cells are formatted as dates in both workbooks. What am I missing?

I searched other forums, and even tried a workaround that someone suggested using the text-to-columns data tool, but it did not work.

Any suggestions/solutions would be greatly appreciated.

 

[Artboy34]

no, not stupid at all, and apologies for the delayed reply. Put that in an empty cell, it is just for a test, you will be removing it once we have established the actual format of those cells

Both appear TRUE.