months calculation
 

Hi

I require formula to calculate the number of months an employee has
completed in an organization using their date of joining.

e.g if an employee joins on 01-Mar-06 his or her six months should in the
next column as 0.6. Moment an employee complete a year it should show 1.0

email ur replies on

Thanks in advance

months calculation
 

Can't see where you get 0.6 from, as that is only 3 months by my calcs,
which is .25, but maybe this helps

=DATEDIF(A1,TODAY(),"y")+DATEDIF(A1,TODAY(),"ym")/12

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sam" wrote in message
...
Hi

I require formula to calculate the number of months an employee has
completed in an organization using their date of joining.

e.g if an employee joins on 01-Mar-06 his or her six months should in the
next column as 0.6. Moment an employee complete a year it should show 1.0

email ur replies on

Thanks in advance

months calculation
 

Bob Phillips Wrote:
Can't see where you get 0.6 from, as that is only 3 months by my calcs,
which is .25, but maybe this helps

=DATEDIF(A1,TODAY(),"y")+DATEDIF(A1,TODAY(),"ym")/12



Couldn't you get the same result with

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=556785

months calculation
 

You could, I was thinking of "ym"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"daddylonglegs"
wrote in message
news:daddylonglegs.2a5snp_1151576707.0537@excelfor um-nospam.com...

Bob Phillips Wrote:
Can't see where you get 0.6 from, as that is only 3 months by my calcs,
which is .25, but maybe this helps

=DATEDIF(A1,TODAY(),"y")+DATEDIF(A1,TODAY(),"ym")/12



Couldn't you get the same result with

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=556785