how to extract number of days in separate months from two given dates

[Crashxtreme]

Hi Guys

I have a really big spreadsheet (about 34,000 lines!) where the amount needs to be apportioned into the relevant months. I have the start date and the end date. I can apportion it manually but it is going to take too long. Can someone tell me a way so that the correct amount drop into the right months. The end result would look like this.

Amount From To May-15 Jun-15 Jul-15 Aug-15
3,500.00 08/06/2015 31/08/2015 947.06 1,276.47 1,276.47



Thanks guys

Crashxtreme

 

[mas123]

Can you upload example
and explain more
?

 

[mole999]

sounds like a job for a pivot table

 

[Crashxtreme]

How do I upload the spreadsheet here?