Isblank and today function

Hi there,

I have a similar query where I have already used the formula given to this thread, but my added secondary level is that if the cell does not have a date in it then it returns #VALUE!

So I have

=IF(ISBLANK(E5)," ",E5-TODAY()) then in next cell =IF(ISBLANK(F5)," ",F5-TODAY())

The results are below: Cell E5 has a date in it and 37 days left is the correct calculation based on today's date

However the #VALUE! result is because cell F5 has text in the cell not a date

I assume it needs to be either an AND OR ISERROR or some combination with my IF ISBLANK above but my brain cannot compute what it needs and neither can Google as I probably am not asking for the correct thing!

Thanks in advance

Riny_van_Eekelen legend thanks mate worked perfect