I have a worksheet in Excel 2003 that has 2 columns with dates paste linked
from another workbook. One is a start date and the other a finish date. I
want excel to automatically default any start date to 1/04/05 where that date
is before 1/04/05, and in the finish date column, to automatically default
the date to 31/03/06 for any dates that are after 31/03/06 or there is no
date at all for that column. I don't want the default dates to alter any
dates that fall from 1/04/05 to 31/03/06 because they will be relevant dates
I need to keep. Can this be done?