Thank you!  This is the first thing that has worked for me and I've tried so many suggestions.  I had to make sure that the "Date2" column was is date format (format the cell) after I put in your suggested formula.  Then i just copied it all for the way down the column by clicking the lower right side of the first formatted cell.