Ok, I've searched quite a bit on this topic and i still can't find what i'm looking for.

I have two columns, both with dates, one for completion and one for delivery.

I have set up conditional formatting to highlight the delivery column in green if the date is less than or equal to the completion date + 14 days and red if the delivery date is greater than 14 days after the completion date.

Completion Delivered ConditionalFormattingColour
12/05/2013 14/06/2013 Red
30/01/2013 08/02/2013 Green
09/05/2013 14/06/2013 Red
31/01/2013 08/02/2013 Green
31/01/2013 08/02/2013 Green
01/02/2013 08/02/2013 Green
12/02/2013 06/03/2013 Red

What i'm trying to do now is have a single cell which shows how many delivery cells are green (i.e. delivery cells that are <= completion +14). For the above example i'm looking for a cell with 4 in.

I've tried countif and countifs and sumproduct but i can't for the life of me figure out how to get the cell range to add 14 days to each cell and count the number of cells that have a delivery date less than or equal to 14 days later the completion date. I'm not that concerned with counting the number of cells that meet the conditional formatting colour criteria as i've seen that i'd need to write some vba to do this and i'm not wanting to go down that route just yet. I'm sure there is a formula that can be written for this, but i'm not clever enough to figure it out just yet.

Hopefully i've attached a sample of the cells with the current conditional formatting and any help with this would be greatly appreciated.

CountCFDates.xlsx