About calculate months between two date (date function)

[Guest]

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

 

[Guest]

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

Dave

 

[Dave Peterson]

First, you'd want to refer to dates like:

date(2006,12,31)

12/31/2006 is 12 divided by 31 divided by 2006.

But to answer your real question, maybe using =datedif() would help.

Except for xl2k, this function doesn't appear in xl's help.

Chip Pearson has some very nice notes:
http://www.cpearson.com/excel/datedif.htm