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, then it returns #VALUE!

So I have =IF(ISBLANK(E5),” “,E5-TODAY()) which gives a result of 37 – as in number of days left as E5 contains a date 37 days from today

But then I have  =IF(ISBLANK(F5),” “,F5-TODAY()) which gives a result of  #VALUE! and this is because cell F5 contains text

I assume it needs to be something like either AND OR ISERROR ISNUMBER combined with the IF ISBLANK above, but my brain cannot compute what it needs and neither can searching for an answer as I probably am not asking for the correct thing!

Thanks in advance

​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, then it returns #VALUE! So I have =IF(ISBLANK(E5),” “,E5-TODAY()) which gives a result of 37 – as in number of days left as E5 contains a date 37 days from today But then I have  =IF(ISBLANK(F5),” “,F5-TODAY()) which gives a result of  #VALUE! and this is because cell F5 contains text I assume it needs to be something like either AND OR ISERROR ISNUMBER combined with the IF ISBLANK above, but my brain cannot compute what it needs and neither can searching for an answer as I probably am not asking for the correct thing! Thanks in advance  Read More

​