Adding dates to each column

Options
Safehavensussex
Safehavensussex ✭
edited 06/06/24 in Formulas and Functions

Hello,

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

· Share on FacebookShare on Twitter

Answers

  • Itai
    Itai ✭✭✭✭✭✭
    Options

    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🙂

    https://www.linkedin.com/in/itai-perez/

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!