Use the DATEDIF function: http://www.cpearson.com/excel/datedif.htm

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Hank" wrote:

Hi, I find out there is no direct function to calculate total months between
two dates, such as I want to calculate how many month from an start date to
year end date (like 12/31/2006), I do figure out the date function but it
looks very complicated, is any easy way?? mine is

=(YEAR(12/31/2006)-YEAR(1/1/2003))*12+(12-MONTH(1/1/2003))+1

the total month is 48, is any easy way???

THANKS
Hank