How to get a Alert in Excel when it reaches to some expire date

[Shard.K]

I created a spreadsheet to track documents. The last column is for expiration dates of documents. How can I set up an alert when the expiration date is approaching.

[Shurod]

Use conditional formatting in the cell. For example, with the date in A12, something like Formula is =TODAY()+7>=$A$12 as the condition. Then choose a pattern.

[Erakna]

There is a formula for the same that you can use. For that type = IF (L2-3 <TODAY (); "RENEWED", "IN PROGRESS") "L2" is my term. You can try the same in different ways also.