You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
Yes this works. and it solves the last of my problems today. You experts
are
diamonds in the rough. Thanks for helping us that struggle.

Mark

"T. Valko" wrote:

E5 is a date

Try this:

=IF(N(E5),E5-14,"")

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
d5 formula is =E5-14 (E5 is a date)

If there is no entry in d5 it reads "Value"

Is there a way for D5 to be just a white cell, without the "value"

Thank you
Mark