Excel - alerts

Hi Lauren

Thank you for your question. To tackle this the problem needs to be broken down further. I'm going to assume that the spreadsheet is made up of rows of records of contacts. With columns like

Name : Company : Contract end date

We want to flag those companies who's contract end date is soon.

To do this we need to compare the contract end date with today's date.

If they are close then we need to display a message such as "Expires soon" otherwise we display nothing. I'll assume that soon equals 7 days from now.

To do this I'll use an IF function in a new column like this


Name : Company : Contract end date : Contract expiry


The formula in the contract expiry cell needs to do the following

check if Contract end date is 7 days or less from today.
If it is then display "Expires soon" in the final (Contract expires) column, otherwise display nothing at all.

If the columns are labelled as follows and formula is on Row 1

A : B : C : D
Name : Company : Contract end date : Contract expiry


the formula in D1 would read

=IF(C1<=TODAY()+7,"Expires soon","")

Try this out and see if it produces the kind of results you want.
This formula can be copied down for the rest of the rows in the sheet.

Thanks,
Andrew