Cell reads "Value" without an entry

[Mark]

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

 

[Max]

Your description is not quite clear
Maybe you meant to do this,
in D5: =IF(ISNUMBER(E5),E5-14,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[T. Valko]

E5 is a date

Try this:

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

 

[Mark]

Dang you guys are good. I just wish there was a proper way to Thank you.

Thank you.

Mark

 

[Mark]

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]

You're welcome. Thanks for the feedback!

 

[Max]

Welcome, Mark
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik