Microsoft office software has a multi-purpose Excel office software application which is a spreadsheet featuring graphic tools, pivot tables, macro programming and calculations like determining the number of days, months and years between two dates for example. Excel office software provides a number of such functions: you can work out the number of months between two dates in two ways: 1. Dates occurring in the identical year or 2. Dates occurring in two different years. To calculate the number of months for case 1, use the MONTH function to take out the month from every date minus the two months at the start and end and for case 2, use the YEAR and MONTH functions. You can also calculate the date after adding the number of months to another date.
[Excel] Calculate number of months between 2 dates
I want to work out the number of months between two dates ex: 01/05/2009 as the starting date and 02/27/2010.
I assume that your dates are set out in this way on your spreadsheet:
1 Start End
2 01/05/09 02/27/10
Thus you can try this formula in C2
And if you want to know a date after adding a number of months to another date :
1 Start Month number
2 01/05/09 2
Try this formula in C2
Thanks to aquarelle
for this tip on the forum.
Published by aakai1056
. - Latest update by Virginia Parsons