"cancel After 90 Days"

Hi,

Here's the deal:

I have a list of names in column D

In Column E is a list of dates corresponding to the names.

I'm trying to create a formula in column F to remove/cancel any name after a 90-day period. Here's the formula I'm using:

IF($F$2-E2>90, "CANCEL","")

I'm getting an error regardin "circular reference"

I've attached the sample. thanks again!

Hi again,

Not sure exactly what you want this time?

The dates in Column E are when they enrolled, and you want Column F to say cancel if that was over 90 days ago?

=IF(((E9+90)<TODAY()),"CANCEL","")

This is saying if the value in cell E9 + 90 days is less than the date today tell me to cancel it. I.e. If that date is over 90 days ago since today then cancel.

Is this what you want?

Michael.

Hi Zachary

Your dates are formatted as text so try this:

=IF(TODAY()-DATE(RIGHT(B2,4),LEFT(B2,2),MID(B2,4,2))>90,"CANCEL","")

or you can change your date format and use:

=IF(TODAY()-B2>90,"CANCEL","")

to change your date format first select your date cells then go to DATA/Text to columns next select "Fixed width" and hit NEXT NEXT then select "Date" from the top right menu, in the drop down menu to the right select DMY and hit "Finish"

Hope this helps!
Jean-Guy