Formula for- (Calculate the number of months between two dates(separate Years/months colum
Hi all,
Please help me solve the month calculation in the image attached below, its urgent , your help is much appreciated!!!!
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
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
Audere est facere
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
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
Quang PT
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
Give 0 if B9 is blank.
=IF(B9="",0,Formula)
Thank you for your expert help. Please help me again on the problem shown on the attached file.
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
Thank you for your expert help. Please help me again on the problem shown on the attached file.
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
Last edited by xcfeng95; 02-20-2014 at 06:20 PM.
Thank you for your expert help. Please help me again on the problem shown on the attached file.
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.
Last edited by xcfeng95; 02-20-2014 at 06:20 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks