Many Thanks XOR. That is exactly how I want it.

I was actually advised to covert the range to a Table. If this is not a matter of importance I will stay with a range.

Your example has allowed me to move my next date column after the last date in the PT. Something I was trying to achieve but failed.

My file proper has over 800 rows and 15 columns so I will try to replicate your formula in that. I certainly don't understand them but will try to work through it.

The only strange thing is Day (Column B) has converted to Scandinavian language, I believe.

Thanks again.

Rob