Forum Discussion
Solved
Date that will automatically highlight after 2 weeks
Hi, I have a spreadsheet with a column of dates that I would like to automatically highlight after 2 weeks. The date column is not sorted as my list is alphabetical according to the name column...
Yes. To illustrate I added current date as =TODAY() (now is Fri, Mar 12) and date two weeks before (Fri, Feb 26). All dates which are older will be highlighted
You may apply conditional formatting rule with formula as
On my PC dates were actually texts, I converted them to date values with Data->Text to Columns wizard.
Please check in attached file.
Thank you for answering! Just to make sure I understand (because I thought that was it but wasnt sure) Using that formula, if I enter a date today into my speadsheet, it will autmatically turn red in 2 weeks from the date entered?