I have two dates.

One is a start date and the other is the end date.

Let’s use 7/15/2006 for the start date and 4/12/2009 for the end date.

What I need to get to (in one way or the other) would look like this:

Start End 2006 2007 2008 2009 2010
7/1/06 4/12/09 5 12 12 4 0

I know I can use DATEDIF to calculate the number of months between the dates (in this case 33). But I’ve been trying for a long time to get a formula to get the number of months in each year IF the dates span over the course of years. I’d like the formula to be good enough where if it is in just one year, it calculates that and if it spans more than one year (like the example above) it will show that data.

Can anyone assist or do they know of an existing formula?

Thanks for the help…