Could anyone helpeith a formula
I have several tasks, each starts at a different time & take varying times
to complete
See table below
Task 1 starts in Jan, lasts for 4 months & I spend £1000 (ie £250/month)
Task 2 starts in Feb for 3 months & costs £3000 (£1000/month)

task start time value Jan Feb Mar Apr
1 Jan 4 £1,000 £250 £250 £250 £250
2 Feb 3 £3,000 £1,000 £1,000 £1,000

I need a formula that matches the start date in ColB with the month (Jan,
Feb etc), calculates the spend/month & fills in the table accordingly.
Dates could be spread ove 2 years

Any ideas