Conditional and If statements using dates as a trigger for an ac

Hi,

I have created a schedule which has dates of the month (...like a calendar) going accross the worksheet, a driver date which is essentially the date of cinema release of a title in column B. Column a has the name of the titles.

What I would like to achieve, is based on the release dates in column B, I would like to have a deadline date which falls exactly 6 weeks after the release date in column B.

Perhaps using a combination of conditional and if functions, as the deadline day approaches to give a warning by colouring the calendar cells different colours. Say for example 1 month away the calendar cells are higlighted a certain colour, changing colour to a different one once two weeks away, and then in the last week to once again a different colour. Once the dealine day is reached and the activity has not been completed colouring the cell red. However at any point once the activity is completed - typing an 'x' would change the colour of the cell to green.

I hope this makes sense, a sample formula and explantion of the parameters to select in conditional formatting which does this would be very much appreciated.

If easier, I already have the spreadsheet but can't seem to attach it here using this post.

Many thanks,

Paul