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

Justine

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.

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:

https://help.smartsheet.com/function/netdays

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

https://help.smartsheet.com/functions

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

cheers,

Kelly