months calculation

S

Sam

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 [email protected]

Thanks in advance
 
B

Bob Phillips

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)
 
D

daddylonglegs

Bob said:
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
Click to expand...

Couldn't you get the same result with

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

Bob Phillips

You could, I was thinking of "ym"

--
HTH

Bob Phillips

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

"daddylonglegs" <[email protected]>
wrote in message
 
Top