# Formula for- (Calculate the number of months between two dates(separate Years/months colum

1. ## Formula for- (Calculate the number of months between two dates(separate Years/months colum

Hi all,

Problem:What's the Formula to calculate number of months between two dates ,(With date separated into 2 columns like Years/months colums show above)? e.g (Y1,Y2,M1,M2)\
---Pls note dates are fix to insert this way in report, we dont want to combine them into one cell.

months cal.PNG

2. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c

If you have today's year in C3 and today's month in D3 then with start year in C4 and start month in D4 use this formula for the number of months

=(C3-C4)*12+D3-D4

3. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c

thank you so much for solving my problem, you are a life saver! I am really not good with excel formulas.

Please look at the new picture, what about when I want to make the "WHOLE COLUMN" with same concept/function applied to a list of candidates automatically? I tried "drag down" to perform function, but it doesn't work that way.

whole comun.PNG

4. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c

I saw daddy may off now. Maybe you can try one of these following;
=(\$A\$3-B9)*12+\$B\$3-C9
or
=DATEDIF(DATE(B9,C9,1),DATE(\$A\$3,\$B\$3,1),"m")

Offcourse, Daddy's is alway the shortest

5. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c

Hi Bebo,

is there a way to put an "exception", like if there is no start dates for contract, then the answer equals to zero, however, the formula for the month calculation column will still be hidden there.

Originally Posted by bebo021999
I saw daddy may off now. Maybe you can try one of these following;
=(\$A\$3-B9)*12+\$B\$3-C9
or
=DATEDIF(DATE(B9,C9,1),DATE(\$A\$3,\$B\$3,1),"m")

Offcourse, Daddy's is alway the shortest

6. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c

Give 0 if B9 is blank.
=IF(B9="",0,Formula)

7. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c

1. (Urgent in a few min)I need a formula to show months.days(month.decimal days,) between two dates that shows Y,M,D.-----(I am unsure if the M.days decimal is possible, if not please provide alternative ways , maybe calculate the total days, then divide by month?....

2. ( Can reply later) I would like to auto update the current days in excel sheet.
excel YMD.PNG

8. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c

Originally Posted by bebo021999
Give 0 if B9 is blank.
=IF(B9="",0,Formula)

1. (Urgent in a few min)I need a formula to show months.days(month.decimal days,) between two dates that shows Y,M,D.-----(I am unsure if the M.days decimal is possible, if not please provide alternative ways , maybe calculate the total days, then divide by month?....

PLEASE ALSO NOTE*( THE MEMBERSHIP LIMIT IS 3 YEARS, SO maybe there is a =3-(formula), to indicate that )

2. ( Can reply later) I would like to auto update the current days in excel sheet.
excel YMD.PNG

9. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c

If you have today's year in C3 and today's month in D3 then with start year in C4 and start month in D4 use this formula for the number of months

=(C3-C4)*12+D3-D4

1. (Urgent in a few min)I need a formula to show months.days(month.decimal days,) between two dates that shows Y,M,D.-----(I am unsure if the M.days decimal is possible, if not please provide alternative ways , maybe calculate the total days, then divide by month?....

PLEASE ALSO NOTE*( THE MEMBERSHIP LIMIT IS 3 YEARS, SO maybe there is a =3-(formula), to indicate that )

2. ( Can reply later) I would like to auto update the current days in excel sheet.

There are currently 1 users browsing this thread. (0 members and 1 guests)