FIRST OF ALL I WANT TO THANK YOU. THE FIRST OPTION DID NOT WORK AS WHEN I COPIED DOWN, IT DELETED THE DATES THAT WERE ALREAY IN COLUMN B. I DID ENTER INTO COLUMN D AND IT WORKS...I WILL HIDE COLUMN C AND NOBODY WILL SEE IT.
BUT IS THERE A WAY FOR COLUMN B'S DATES BE NOT AFFECTED? IT CHANGE...
I HAVE TWO COLUMNS IN DATE FORMAT. COLUMN A IS COMPLETELY FILLED WITH DATES AND COLUMN B HAS SOME DATES AND BLANKS.. I INSERTED COLUMN C AND PUT =TODAY()-A1 SO THAT I WOULD KNOW HOW MANY DAYS BETWEEN THE FIRST DATE AND THE PRESENT DATE. I WANT TO ENTER IN COLUMN B WHERE THERE ARE BLANKS TEXT...