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
|