Accumulative date formula required

whitney.thomas

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

KPH

Hi

I think this is a duplicate of:

https://community.smartsheet.com/discussion/121363/accumulative-formula-required

If not and you need help, please reply.