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
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?
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
- thank you!
I will give it a try!Marie_RC , you are welcome