It there a formula to use so that I can calculate an amount between dates?
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
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!