SOLVED

# Isblank and today function

Copper Contributor

# 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

4 Replies
best response confirmed by Tom3112 (Copper Contributor)
Solution

# Re: Isblank and today function

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

# Re: Isblank and today function

@Riny_van_Eekelen legend thanks mate worked perfect

# Re: Isblank and today function - with a non-date cell

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!

# Re: Isblank and today function - with a non-date cell

Perhaps like

1 best response

Accepted Solutions
best response confirmed by Tom3112 (Copper Contributor)
Solution

# Re: Isblank and today function

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