It there a formula to use so that I can calculate an amount between dates?



I am trying to calculate the amount outstanding between certain dates, but I can't figure out what to use or if that is even possible.


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Justine

    Yes. Smartsheet has several functions that calculate between dates. The different functions allow you either calculate the absolute total between two dates, ignore weekends, or add an additional day if a weekend is in the range.

    The basic function is NETDAYS. You can find information about that, as well as references to the other functions, here:

    It's hard to keep up with all of the smartsheet functions. A complete list of them can be found here:

    Let us know if you have any trouble working the formula into your sheet and we can help with that.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!