Formula to count days between a date and TODAY, ignore blanks

Hi -

I have a column titled NIGO Date, which may or may not have a date. I then want a formula in the next column Age of NIGO that will count the days between that date and today. I also need it to ignore blanks.

I have tried a ton of different formulas and keep getting #Unparseable errors.

This is what I"m starting with, which works, until the cell is blank.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!