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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!