date formula

[Juco]

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

 

[Niek Otten]

=IF(AND(E7=0,D7=0,C7=0),DATE(2005,1,1),DATE(E7,D7,C7-42))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Juco]

Thanks Niek,

That works great.

=IF(AND(E7=0,D7=0,C7=0),DATE(2005,1,1),DATE(E7,D7,C7-42))

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel