formula: rolling cost projections using Start and End dates
We are trying to put together a formula, for rolling cost projections using Start and End dates, but if Start Date is earlier than "Today's Date", I need the formula to split up a value of the backlog equally by QTR from TODAY's DATE to End Date. We have the TODAY date working, I just need to split out a value from remaining duration of a project by QTR equally. Do I need to use a Metric sheet, to tie the information in, or is there a formula that I can use?
Help Article Resources
Check out the Formula Handbook template!