No formula result if no input information

[Robert_Conklin]

I am currently using the following formula to calculate how many days have passed since the last actioning date.

=DAYS(TODAY(), [@[LAST ACTIONING DATE]])

How can I modify this formula to not return a result in the Actioning Date cell is blank?

Thank you for any assistance.

 

[Peter_SSs]

I suggest that you update your forum profile (click your user name at the top right of the forum, then ‘Account details’) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try

=IF([@[LAST ACTIONING DATE]]="","",DAYS(TODAY(),[@[LAST ACTIONING DATE]]))

or without the DAYS function you can just subtract

=IF([@[LAST ACTIONING DATE]]="","",TODAY()-[@[LAST ACTIONING DATE]])

 

[Robert_Conklin]

Thank you very much, Peter. Your first formula worked like a champ!

 

[Peter_SSs]

Thank you very much, Peter.

You're welcome. Thanks for the follow-up.
.. and for updating your profile.

Your first formula worked like a champ!

The second one should too - but of course you can choose whichever one you want.