Hi,

I have a data set that has invoice amounts with corresponding bill date range. I need to get those invoice amount auto pop up in correspond month columns.

Invoice Number Bill From/Bill To Invoice Amount Dec '13 Jan '14 Feb '14
1 01/01/2014 00:00 $100
01/02/2014 00:00

2 12/30/2013 00:00 $200
12/30/2014 00:00

3 01/01/2014 00:00 $300
01/02/2014 00:00

Can someone please help me?
Thank you so much!

Excel Question.xlsx