Hi Tom,

Many thanks, looks ok at first glance and sorry if I did not expand but if I copy the columns with formulas and paste (values) I still see the full string of date and time which then causes an issue when I try to filter the column (I just want to see the date in the filter and no time) , which was my next stage ( sorry I did not make this clear).

Would appreciate any expansion on this.

G