I would like to use the date that text is entered into a cell as the criteria for a formula. A "C" is entered to indicate that a particular record is "Canceled" - If it was entered today()-7, I'd like it to show a status of "New Cancellation", otherwise, "Canceled".

Is this possible?

TIA,
Jill.