I am trying to write a formula for conditional formatting that will fill a cell yellow if the date contained in the cell is between today's date and today's date plus 7 days. I initially thought that something like:
=TODAY()<=E2>=(TODAY()+7)
but that doesn't work (or any variation of that formula like switching the < signs around)
Any help would be really appreciated!
Bookmarks