Hi, You solved my problem posted in thread http://www.excelforum.com/excel-gene...-column-b.html Thank you very much for that. Is there any way that these dates CUT out from Column A? Not Copied But Cut out or you can say Trim out. So the dates are in Column B and not present in Column A any more.. Thank you very much