# 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  Register To Reply

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  Register To Reply

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  Register To Reply

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   Register To Reply

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   Register To Reply

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)  Register To Reply

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  Register To Reply

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  Register To Reply

9. ## Re: Formula for- (Calculate the number of months between two dates(separate Years/months c Originally Posted by daddylonglegs 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.  Register To Reply

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