hi Team,
i have coloumn A and B with list of dates. Coloumn A has earlier dates when compared to coloumn B.
i am trying to find a formula with which i can know the difference between the dates in "number of months".
Ex: Coloumn A has 06/01/2014 and Column B has 08/30/2014. The difference between the dates in terms of month is 3 which i need in a formula.
Please help.
http://office.microsoft.com/en-gb/ex...003056111.aspx
Looking at your example, I would say there is two months difference between those dates, which I think is what the formula in the link would return. Maybe you could change it to:
=(YEAR(B1)-YEAR(A1-1))*12+MONTH(B1)-MONTH(A1-1)
Assuming that your dates are always the first and last of a month.
hi,
Try this formula
=ROUNDUP((B1-A1)/30.5,0)
Punnam
try =DATEDIF(A1,B1,"m") for date difference in months or =DATEDIF(A1,B1,"ym") for a difference between the months by month only. The first will give you the total months difference so 8/11 and 6/14 is 34 using the first, it is 10 using the second. The first uses months and years and the second uses months only.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
The formula works perfectely fine but i didnot understand the difference between =DATEDIF(A1,B1,"m") and =DATEDIF(A1,B1,"ym").
Can you explain in detail please.
let's say that your months are 5/1/2011 and 6/15/2014, for the first (using "m") will give you the total # of months between the two dates, in this case 37 months. Now the second using "ym" will give you the total months ignoring the year values so you would get 1 - one month difference between May and June whereas the first would give you 37 months difference between May 2011 and June 2014. The first is months difference taking into account years while the second ignors years and only looks at months (seems backwards doesn't it?).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks