In cell M26 I have the fllowing formula...
=DATE(E7,D7,C7-42)
If cells E7,D7,C7 are blank ie no date in them
How can I get a default date of 1 jan 2005 to appear

thanks