Hi,

I am using this formula and it is coming out to be 3 which is correct. We are now for example in January and as we do not count any months that have started I want to calculate the remaining months from the February to the end date on the sheet.

Example we are in January so the equation would return the following results

01-Jan-12 29-Mar-12 2
01-Jan-12 29-April-12 3
01-Jan-12 29-June-12 5

Hope this is clearer.