Forum Discussion
AS2021
Sep 15, 2021Copper Contributor
Conditional formatting not reading dates
Good morning, I have a spreadsheet in which dates have been formatted as dates in the Home tab, and where I already tried using "Text to Columns" in the Data tab to make sure the dates are format...
Riny_van_Eekelen
Sep 15, 2021Platinum Contributor
AS2021 Remover the quote marks surrounding =TODAY(). Then it will work.