Hi there,
Firstly, disclosure - I've cross-posted this from Excelforum (http://www.excelforum.com/excel-gen...months-across-periods-in-which-they-fall.html). I've not had any responses so far and could really do with a response before I waste tomorrow doing this manually!
I have several hundred date ranges i.e. 1/1/09 - 1/1/11. I'm trying to allocate the number of months in each across the financial years ended 31/7/08 - 31/7/19 e.g. months in the financial year ended 31/7/09 would return 7 months and 31/7/12 onwards would return nil. I've linked an example of what my spreadsheet looks like - https://dl.dropbox.com/u/161000/Example (1).xlsx . Hopefully this makes it fairly obvious what I'm looking to achieve!
I've found the following thread - http://excel.bigresource.com/Track/excel-5l9CSSlj/ - which is trying to achieve the same as I am, except in terms of days/months rather than months/years - however, I've not had much luck modifying the formula for my own use. The first row in the linked file gives an idea of what I've done.
So - can anyone advise where I'm going wrong? Any help would be much appreciated!
Firstly, disclosure - I've cross-posted this from Excelforum (http://www.excelforum.com/excel-gen...months-across-periods-in-which-they-fall.html). I've not had any responses so far and could really do with a response before I waste tomorrow doing this manually!
I have several hundred date ranges i.e. 1/1/09 - 1/1/11. I'm trying to allocate the number of months in each across the financial years ended 31/7/08 - 31/7/19 e.g. months in the financial year ended 31/7/09 would return 7 months and 31/7/12 onwards would return nil. I've linked an example of what my spreadsheet looks like - https://dl.dropbox.com/u/161000/Example (1).xlsx . Hopefully this makes it fairly obvious what I'm looking to achieve!
I've found the following thread - http://excel.bigresource.com/Track/excel-5l9CSSlj/ - which is trying to achieve the same as I am, except in terms of days/months rather than months/years - however, I've not had much luck modifying the formula for my own use. The first row in the linked file gives an idea of what I've done.
So - can anyone advise where I'm going wrong? Any help would be much appreciated!