calculate number of months based on one date

[JK]

In excel, how do you calculate the number of months that have passed between
the first of the year and the one date that is available on the worksheet? In
other words, if I enter today's date in a field on my worksheet, I want a
formula to automatically display the number of months that have passed since
the first of this year and the date I entered. Everything I see is based on
the number of months between two dates. I only have one.

I appreciate your help!

Jason

 

[Mike H]

Hi,

With your date in a1 try this

=DATEDIF(DATE(YEAR(A1),1,1),A1,"m")

datedif isn't documented in Excel, for help look here

http://www.cpearson.com/excel/datedif.htm

Mike