Sean, Your solution worked! Thank you so much for sorting this mystery. I am in the UK so the date format is the same as for Ireland. Another slice of Excel knowledge gained by me .
CA3LE - Yes please - if you can add the site option for the date format that will make it a whole lot easier for those of us on this side of the pond.