Ah, that's a different issue. What format do you want the result in?
On 05/06/2007, at 1:24 PM, John Wenmeekers wrote:
Thanks for the reply Nicolas, but that's not the problem.
I know how to calc how many months, the result will be a number....
The problem is that I have to know which month and how many time that
month is in the range.
f.i. I have a range from Feb 12,2006 to August 15, 2007.
Januari = 1 time in the range (in 2007)
Feb = 2 times in the range (a part in 2006, as a whole month in 2007)
Mar = 2 times (2006 and 2007 )
Apr = 2 times
...
...
August = 2 times (as a whole month in 2006 and a part in 2007)
See the difference. Not the number of months, but the names and how
many
times....
But thanks anyway....