Isblank and today function

[Tom3112]

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

[#2 · Accepted solution]

@Tom3112 

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

[#3]

@Riny_van_Eekelen legend thanks mate worked perfect