Forum Discussion

Tom3112's avatar
Tom3112
Copper Contributor
Feb 03, 2023
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...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 03, 2023

Tom3112 

=IF(ISBLANK(A3),"",TODAY()-A3)

LisaBF560's avatar
LisaBF560
Copper Contributor
Jul 25, 2024

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

 

Resources