Formula to count no. of months between 2 dates

M

Melissa

What is the formula to display the number of months between 2 dates?

Thanks,
Melissa
 
M

Melissa

I forgot to mention I am using Excel 2000.
I used this formula: dateif(A3,A2,"m") and got a #NAME? result.
My dates are all in column A (in ascending order).
 

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

Similar Threads

Expanding Date formula 1
Formula Help 2
Formula to assist with counting dates 2
calculate number of months based on one date 1
Excel Help with dates 2
counting the number or months between two dates. 5
Count specific days in between dates 2
Counting calendar Days - not including Sundays 3

Top