Formula to Change Date to # of Mths worked

[Kristylee0228]

Hi All,
Just wondering if there is a formula where I can change the date an employee started working into the number of months employed??
Example, John Smith started here in January 2011. I would like the formula to return 8 months.

thank you!

Kristy

 

[Matt Rogers]

Hi.

Maybe ...:

Excel Workbook
	A	B	C
1	Month/Day/Year	- Month	Result
2	01/01/2011	8	05/01/2010
Sheet

 

[Sahak]

Hi Kristy,

=MONTH(NOW()-MONTH(A1))-1

 

[adam087]

[edit] removed as not posted correctly

Regards
Adam

 

[Kristylee0228]

thank you for your responses!

@Sahak,
I hate to be a bother, but could you just explain what the blank parenthesis are after NOW? I just want to understand exactly what I am entering. Still kinda new here... Sorry..
But thank you very much!!!

 

[Kristylee0228]

The formula did not work the way I had hoped. I put it in for an employee who started here in 2008 and the formula returned the number 9, where it should have returned 36... for 36 months.

 

[Sahak]

How i know, there is no explanation for (), Excel understand that way.

=(YEAR(NOW())-YEAR(A1)+1)*(MONTH(NOW()-MONTH(A1)))

if date is 01/01/2008 then formula will give you 36

 

[Sahak]

Kristy,

Please ignore previous, try this:

 =INT((NOW()-A1)/30)

or

=ROUND((NOW()-A1)/30,0)

 

[Kristylee0228]

thank you very, very much!!
It worked. Much appreciated!

 

[barry houdini]

To get the number of whole months between two dates you can use DATEDIF, e.g.

=DATEDIF(A1,TODAY(),"m")