ExcelBanter - Number of months

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Number of months (https://www.excelbanter.com/excel-programming/443360-number-months.html)

gcotterl[_2_]

Number of months

How can I compute the number of months between January 1950 thru
December 1980 and July 2010?

Harald Staff[_2_]

Number of months

Hi

Use DATEDIF for this:

=DATEDIF(A1,B1,"m")

See http://www.cpearson.com/Excel/datedif.aspx for theory, the function is
undocumented in Excel.

HTH. Best wishes Harald

"gcotterl" wrote in message
...
How can I compute the number of months between January 1950 thru
December 1980 and July 2010?

All times are GMT +1. The time now is 06:51 AM.