Isblank and today function

New Contributor



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



2 Replies
best response confirmed by Tom3112 (New Contributor)



@Riny_van_Eekelen legend thanks mate worked perfect