Difference in months given two dates

[BenNV]

Is there away to calculate the difference in months if we are given two months?

So say we have:

17-Apr-02 17-Oct-02

The difference in months is 6

So in the 3rd column 6MTH would be calculated.

I would need to account for dates which are maybe a day or two out. So, if we had:

17-Apr-02 16-Oct-02, this would still output 6Mth

 

[Legacy 98055]

Hi BenNV
Guess new code did not work?

Anyway, this formula is only good for 12 months from the starting date.

If starting date is in A1
ending date in B1

=IF(MONTH(A1)<MONTH(B1),MONTH(A1)-MONTH(B1),12-MONTH(A1)+(MONTH(B1)))

13 months shows as -1

Tom
This message was edited by TsTom on 2002-04-10 06:51

 

[Aladin Akyurek]

On 2002-04-10 06:21, BenNV wrote:
Is there away to calculate the difference in months if we are given two months?

So say we have:

17-Apr-02 17-Oct-02

The difference in months is 6

So in the 3rd column 6MTH would be calculated.

I would need to account for dates which are maybe a day or two out. So, if we had:

17-Apr-02 16-Oct-02, this would still output 6Mth

How about simpler:

=INT((B1-A1)/30) or

=INT((B1-A1)/30)&"Mth"

to be entered in C1?

Try also ROUND:

=ROUND((B1-A1)/30,0) or

=ROUND((B1-A1)/30,0)&"Mth"

Aladin