Forum Discussion
Solved
Isblank and today function
Hi, Wondering if someone can help I am using the today function to to calculate how many days has elapsed from a certain date My dates are in Cells A3 - A99 and the answer of how how many...
=IF(ISBLANK(A3),"",TODAY()-A3)
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
| 37 | #VALUE! |
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
