Formula for expenses

[belpal01]

Hi there, I hope someone can help.

I have a spreadsheet where on worksheet 1: I document all events invoices in Excel. This includes the date the invoice is submitted for payment, the date the event takes place on, the cost centre it relates to, the P&L Ledger code, the supplier and the cost.

On worksheet 2: I have a calendar from Jan to Dec in individual columns. I need to be able to be able plot the events that are listed in worksheet 1 over the entire year under the respective month (based on the date the event takes place).

Can this be done by formula?



WORKSHEET 1:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]INV DATE[/TD]
[TD]EVENT DATE[/TD]
[TD]COST CENTRE[/TD]
[TD]GL CODE[/TD]
[TD]EVENT[/TD]
[TD]COST[/TD]
[/TR]
[TR]
[TD]5 May[/TD]
[TD]1 Sep[/TD]
[TD]1000[/TD]
[TD]1234[/TD]
[TD]Spring Fayre[/TD]
[TD]£1000[/TD]
[/TR]
[TR]
[TD]1 June[/TD]
[TD]14 Dec[/TD]
[TD]2000[/TD]
[TD]1234[/TD]
[TD]Christmas event[/TD]
[TD]£2000[/TD]
[/TR]
[TR]
[TD]1 Aug[/TD]
[TD]15 Sep[/TD]
[TD]1000[/TD]
[TD]1234[/TD]
[TD]Summer event[/TD]
[TD]£1500[/TD]
[/TR]
</tbody>[/TABLE]


WORKSHEET 2:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]COST CENTRE[/TD]
[TD]JAN[/TD]
[TD]FEB[/TD]
[TD]MAR[/TD]
[TD]APR[/TD]
[TD]MAY[/TD]
[TD]JUN[/TD]
[TD]JUL[/TD]
[TD]AUG[/TD]
[TD]SEP[/TD]
[TD]OCT[/TD]
[TD]NOV[/TD]
[TD]DEC[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1 Sep Spring Fayre
15 Sep Summer event[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]14 Dec Christmas event[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance.