Adding dates to each column



I wonder if you can help me - I have a column with a date in it, and the following column I would like it to add how many days it has been since that date.

Does anyone know the formula for this?

Thank you


  • Itai
    Itai ✭✭✭✭✭✭

    Hi @Safehavensussex

    Have you tried =Today()-date

    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!