Thread: calculate month
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger
 
Posts: n/a
Default calculate month

RJ --
In the last response, don't use 30.4 -- that's days in a month. Use 12 --
months in a year.

My bad.

"RJ" wrote:

How can I calculate the number of months (or years) between two dates, such as
06/11/2000 and 09/20/2005?