ExcelBanter - how do I set up an entry so that 3 months or one year later Excel.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I set up an entry so that 3 months or one year later Excel. (https://www.excelbanter.com/excel-worksheet-functions/17298-how-do-i-set-up-entry-so-3-months-one-year-later-excel.html)

jhg1226

how do I set up an entry so that 3 months or one year later Excel.

I am setting up a report that has several dates that must be met. For
example a XX214 report is due every 3 months. I want Excel to alert me by
either turning the font red or in some other manner that the report is
overdue.

All times are GMT +1. The time now is 12:51 PM.