Today number of days between a project start date and todays date


Hi All,

I have what I am sure to be a simple formula yet can't figure this out. I need a formula to calculate the number of days between the project start and today's date. So that every day I open the sheet that number will change pending days the project is still active/ open.

Thank You!


  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭


    Use the =today() in the cell and that will update everyday.

    There are a number of formulas you can use. With using [Finish]-[Start] when I used 14 Oct as the start and 14 Oct as the finish the result was zero (0). Using netdays gave the answer of 1 which would mean you have spent one day on the project and that would probably be a better one to use (especially if these days are billed)

    Kind regards


    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!