Default Dates

[Sue]

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?

[Damon Longworth]

You can use something similar to:

if(link<startdate,startdate,if(link>finishdate,finishdate,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" <[email protected]> wrote in message
news:[email protected]...
>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?