How to generate a status indicator

Hi everyone

I'm sorry if this is a simple question.... it might just be that I'm very fed up with this spreadsheet I'm working on and need a break!

But.... I have a sheet with work tasks on. Column I shows the completion date for each project. In column J I would like an automated response linked to todays date. Can we use row 2 as our example? So I need in this case cell J2 to show the following:

- If todays date is more than 5 days before the completion date (in cell I2) I would like the cell J2 to show "IN PROGRESS"
- If todays date is less than 5 days before the completion date (in cell I2) I would like the cell J2 to show "AT RISK"

Is that possible?

Many thanks in advance for any help.

Thanks! That's great. I was nearly there! The only problem I have is that J2 is still showing AT RISK as a default even when I2 is empty / blank. Is there any way to avoid that, so that it only shows a status when there is a date in I2? Thank you!

Thanks Sixthsense!