rounddown with date calc?

L

Ltat42a

I'm trying to determine the number of years someone has on the job.
I'm using this formula - =DATEDIF(B7,TODAY(),"m")/12.

This gives me a result of 13.92, how can I round down this calculatio
to 13.0?
If I remove the decimals...it rounds up to 14 - which is an error.

Thanx
 
B

Bart Snel

Ltat42a schreef:
I'm trying to determine the number of years someone has on the job.
I'm using this formula - =DATEDIF(B7,TODAY(),"m")/12.

This gives me a result of 13.92, how can I round down this calculation
to 13.0?
If I remove the decimals...it rounds up to 14 - which is an error.

Thanx.
Click to expand...
use ROUNDDOWN(cell;number of digits)

Bart Snel
 
R

RagDyer

Try this:

=FLOOR(DATEDIF(B7,TODAY(),"m")/12,1)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
P

Peo Sjoblom

Why not using?

=DATEDIF(B7,TODAY(),"y")

for years

otherwise

=FLOOR(DATEDIF(B7,TODAY(),"m")/12,1)
 
R

Ron Rosenfeld

I'm trying to determine the number of years someone has on the job.
I'm using this formula - =DATEDIF(B7,TODAY(),"m")/12.

This gives me a result of 13.92, how can I round down this calculation
to 13.0?
If I remove the decimals...it rounds up to 14 - which is an error.

Thanx.
Click to expand...

How about

=DATEDIF(B7,TODAY(),"y")


--ron
 
L

Ltat42a

I used both of these -
=DATEDIF(E5,TODAY(),"y")
and
=FLOOR(DATEDIF(B5,TODAY(),"m")/12,1)

They both work good. Thanx All!


Ji
 
Top