How to determine the number of months between 2 periods?
 

Hi,

Let's say your dates are like below:

A

1 05/01/2006
2 06/01/2007

enter this formula in the cell A3

=(YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)

Thanks,

--
Farhad Hodjat


"Eric" wrote:

Does anyone have any suggestions on how to determine the number of months
between 2 periods? such as
01 May, 2006 and 01 Jun, 2007, there is 13 months between 2 periods,
The default day for each period is 1 of each month.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric