Accumulative date formula required
I require a formula that calculates the PRODUCTION PACE of completed builds to number of days in the working quarter.
Currently we are calculating the pace off the total number of days in the QTR (eg. 61 days from April to end of June), but this is not working for us as the pace is too larger for the actual pace we are doing.
I think we need a formula thats calculates the number of days past since the start date of the qtr (eg. 1st april) and then we calculate the pace from completed builds / number of days past. I'm not sure how to make this formula work though.
Can anyone suggest something that works? 😄 it would help our whole company out greatly.
Thanks,
Whitney
Answers
-
Hi
I think this is a duplicate of:
If not and you need help, please reply.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!