About calculate months between two date (date function)



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


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


Dave Peterson

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


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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question