Thanks Colin, but I can't seem to get them to return the results I would expect. The results they are returning are as follows:




Formula1 3
Formula2 01/02/2012
Formula3 40940

The result should in face be 2 as Jan - March is 3 months, we do not want to include the current month (Jan) so want the formula to calculate from Feb - March which would me 2 remaining months.

Your second formula is similar to what I have been trying to do but just can't seem to get it to work.

Hi Caz,

I've attached an example which implements the formulae I posted above. For 1 Jan 12 vs. 29 Mar 12 it gives the result of 2 which I believe is what you want.

Note the formula in D2 is just a helper, so that the formulae in D4 to D9 are simpler.


If it's not returning the correct results then please elaborate.

Attached Files

Book1.xls (14.5 KB, 9 views)