Forum Discussion
ISBLANK used with TODAY() but text in cell gives a #VALUE! error
Hi there, I have formula to give a blank if there is not an entry in the cell I am calculating the date on, but my added secondary level is that if the cell contains text rather than a date in it, th...
Detlef_Lewin Hi there and thank you, this does remove the #VALUE! error which is great, but because there is no ISBLANK now I have the problem of any blank cells returning the value of -45499.
So perhaps it's a combination of ISBLANK AND ISTEXT, so now I need to work out if it's an OR within the IF or something like that...
*ANSWER
Brilliant!! With your help of ISTEXT and getting the parenthesis in the correct places(!!) I have ended up with the below so I thought I would post in order to help others 
=IF(OR(ISTEXT(E3),ISBLANK(E3))," ",E3-TODAY())
- Yes! Thank you that works also, much appreciated!