How Many Months Formula

[George]

Can someone help me with the following:

I am trying to figure out a formula to calulate how many months it has been
between two dates, today's date and the date entered in cell C-2

Is that possible ?

Thanks - George

 

[Dave Peterson]

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

 

[George]

Checked out web site - looks like great information,
but all greek to me - need a novice approach.

 

[Dave Peterson]

=DATEDIF(a1,a2,"M")
Format as General.

Checked out web site - looks like great information,
but all greek to me - need a novice approach.

 

[JP]

Dave,
I think you meant

=DATEDIF(C2,NOW(),"M")

?


--JP

 

[George]

Thanks - That Works...

Dave,
I think you meant

=DATEDIF(C2,NOW(),"M")

?


--JP

 

[Dave Peterson]

I didn't mean that, but I should have!

I could have meant this, too:
=DATEDIF(C2,today(),"M")