Openoffice Calc Spreadsheet – Calculate Number Of Months Between Two Dates

If you want to get the number of months between two fields / dates in Openoffice Calc Spreadsheet, here’s a quick formula:

Openoffice – Calculate Months Between Dates

To calculate months in numbers, in between two given date fields, all you need to do is to use the formula MONTHS with the following three input parameters.

Suppose we have a field A1, having value 2012/01/01, and second field B1, with the value 2012/02/01, in the format YYYY-MM-DD, and we need to calculate the months coming in between these two fields, we will use the following formula in a new field as:

=MONTHS(A1,A2,1)

This will return 13, as we have given the values as January 01, 2012 to February 01, 2013.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>