You can use something similar to:

if(link<startdate,startdate,if(linkfinishdate,fin ishdate,link))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Sue" wrote in message
...
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?