LinkBack URL
About LinkBacks
Given a specific date eg. 07/05/2010 to 06/05/2011, how do we set the formula to auto calculate the months between the dates? In this example, the date will be taken as beginning of the month (ie. 01/05/2010)
Given a specific date eg. 07/05/2010 to 06/05/2011, how do we set the formula to auto calculate the months between the dates? In this example, the date will be taken as beginning of the month (ie. 01/05/2010)
Last edited by gilbert; 07-12-2010 at 03:06 AM. Reason: Problem solved. Thanks to the forum contributors.
Thank you in advance,
Gilbert
Try:
=DATEDIF(A1,B1,"m")
Where A1 and B1 have start/end dates, respectively
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
It didn't return the correct number of months.... it only return 11 months, which if you compute manually, it should be 12 months. Is it alright to amend the formula as below :-Originally Posted by NBVC
=DATEDIF(A1,B1,"m")+1
If you want to include the start month, then yes add +1
See here http://www.cpearson.com/excel/datedif.aspx for a complete explanation of how the dates are counted with the DATEDIF() function...
Thank you very much for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks