EXCEL question - re: dates and alerts

lisa76

Hi all!

Right, I am creating a spreadsheet to show all our contractors public liability insurance.

It will show names, address, and valid to and valid from.

What I need Excel to do is alert me somehow when the valid to date is nearly up - for example two weeks before the date i get a flag or alert or something.

Is it possible for Excel to do this??????

overworked_underpaid

I have found the following site very useful for Excel related queries:

http://www.mrexcel.com/board2/viewforum.php?f=2

bingo_bango

It should be possible to write a conditional formula to do this.
Something along the lines of
=IF(Date Cell-TODAY())=14,"send letter", "Date Cell")
This should get Excel to check the date each time the sheet is opened, and if the renewal date is 14 days away, it will say to send a letter. Hard to be more specific without seeing the sheet.

maforduk

I've sent you the spreadsheet you requested.

lisa76

Thank you everyone - esp you maforduk.

I've joined the MrExcel message board, so hopefully I won't have to bother you kind people on here again.

Thanks

maforduk

If you can't find what your looking for, give me a shout. I'll see what I can do.

cwoodham

Lisa76,
There was a good thread here recently with info on using conditional formatting in Excel to change text colour as you approach a date.