quekbc, my dates cells are all formatted as dates not text, I suspect I've made an error with the formula somewhere.

You have a good point about the alansidman solution not differentiating between years.... I fiddle with it for a while and see if this becomes an issue.