Hi kenkie,

Many thanks for your quick reply.

Unfortunately I changed the 2nd code as suggested, but I still have the same problem. Tried entereing 'h' or 's' into the cells from 26/12/2011 onwards, and it was still pushing the qualifying date back.