Hi I'm not the best at formulas I know what I want but haven't a clue how to get it, tried looking at the help section and not sure if its a EDATE, IF or countif function I use.

what I have is a column that tells me when a licence is due for renewal, the person has a 4 month window to renew the licence I would like a column that tells me in days and that counts down how long they have to renew and when it gets to a certain length of time it changes colour to prompt me to act on this, can anyone help!!!

Hope I've explained what I want ok.

Sally