I'm looking for help with a formula to distribute an amount across the impacted months based on a date range.
Total Cost is $100,000.00
Start Date is 1/17/18
End Date is 4/8/18
I'd like the formula to consider only working days. Can anyone help with a formula that will tell me how much of the cost will be in Jan vs Feb vs Mar vs Apr?
Thanks.
Nadine