date formula
 

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

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

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

Thanks Niek,

That works great.


"Niek Otten" wrote in message
...
=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" wrote in message
.. .

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