How to spread costs evenly across months, if they fall within those dates


I have various financial line items that span different dates. I'd like the costs to be spread per month automatically based on the date and cost entry.

I've tried various functions already, IF, AND, and it says Unpearsable.

I'd like to spread out the costs in the Cost column to the months on the right, based on the start and end date entered. Also, if a cost shows up in the month cell, I'd like the cell color to change (can do this with conditional formatting once the cost shows up).

Really appreciate the help!!

Best Answers