I can only seem to find info on this where there is a specific date range or they only want to highlight an individual cell.
I currently have this as my formula which highlights the entire row if the date in cell "T" is exactly 14 days from today's date, but not between, i.e. today it would highlight only dates that have 6/30/2011. I need it to highlight the entire row if the date falls between TODAY() and 14 days from today.
=INDIRECT("T"&ROW())=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+14)
I know it's close, just need to know where/what to add to it.
Thanks!
Toni
I currently have this as my formula which highlights the entire row if the date in cell "T" is exactly 14 days from today's date, but not between, i.e. today it would highlight only dates that have 6/30/2011. I need it to highlight the entire row if the date falls between TODAY() and 14 days from today.
=INDIRECT("T"&ROW())=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+14)
I know it's close, just need to know where/what to add to it.
Thanks!
Toni