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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!