View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default 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?