Forum Discussion

Tom3112's avatar
Tom3112
Copper Contributor
Feb 03, 2023

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 days has elapsed is in the Y column

 

If there is no date inputted in the A column then it shows 44960 and then corrects itself once you input a date - i am wanting the cell to be blank if no date is put in 

 

Can someone help? i have tried isblank and today functions together but keep getting errors as i have very limited knowledge of excel

 

thanks

excel
    • 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