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

12/03/21
Answered - Pending Review

Hi!

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.

Answers

  • Kelly MooreKelly 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.

    cheers,

    Kelly

Sign In or Register to comment.