Data formating

Hi Lorna

Thanks for your question

We first need to check if the dates are in fact being entered in a recognisible date format. Can you check to see if they are right or left aligned in the cell, and then please advise me.

If left aligned then they are being formated as text, and this would explain the problem

Thanks

Stephen