I have a monthly amount that I need to spread equally over the number of days in the month. The data looks like this:
Month Value 01-Jan-2012 100000 01-Feb-2012 121002 01-Mar-2012 123123 01-Apr-2012 118239
I have to spread the Jan amount over 31 days, the Feb amount over 29 days and the March amount over 31 days. So I can graph it by Day and by an average. Help.