Calculating how many months left.

[EmilVictor]

Hi guys

Hope you can help

what i wanted is a function that would automatically calculate how many months left to get to that month.


say for example

our target month is June 2015

1) May 3 2015 - so to get to June 30 2015 the answer is = 1 month
2) December 8 2014 = 6 months
3) June 23 2014 - 12 months

i dont care about days. even if its 29th of the month.

Thanks

[LokeshKumar]

Hi,

I have solved please a have look in attachment.
Solved Month.xlsx
If this is solved please add the reputation.

[ranman256]

E1 is the answer:

a1 = 7/7/15
b2 = target date
c1 = =YEAR(A1) & TEXT(MONTH(A1),"00")
d1 = =YEAR(B1) & TEXT(MONTH(B1),"00")
e1 = =C1-D1

[Ron Coderre]

With
A1: a target date......30-Jun-2015
and
A2: a start date.....03-May-2015

This formula counts the number of whole months between the start date and the target date

Please Login or Register  to view this content.

Here are some sample results:
03-May-2015......1 Month
08-Dec-2014.......6 Months
23-Jun-2014.......12 Months



Is that something you can work with?