Help with formula

[Ltat42a]

Hi All,
I'm using this formula to calculate the number of years on the job -
=IF(I6<>"",DATEDIF(I6,TODAY(),"m")/12,"")

It works real well. I have a new project to work on using the sum
of this formula. I need this formula to round down the sum.
If I format the cell to whole numbers, it's rounding the number
up or down depending on the sum.

If the sum = 21.92 - the format is rounding the number up to 22 and
it's throwing off my new project. I need it to round the number down to a whole number (21).

Any suggestions??

Ltat42a

[VBA Noob]

Hi,

Try

=IF(I6<>"",INT(DATEDIF(I6,TODAY(),"m")/12),"")

VBA Noob

[Ltat42a]

WOW!!! That works good - Thanx!!

Lt

[VBA Noob]

Glad it worked for you

VBA Noob

[Ltat42a]

Hi,

Try

=IF(I6<>"",INT(DATEDIF(I6,TODAY(),"m")/12),"")

VBA Noob

Question....is there a way that the cell can show "0".
For instance...a person who is promoted 06/01/2006, the results of this cell
should show zero instead of blank. On 06/01/2007 - it will read 1.

Is that possible?

[VBA Noob]

Hi,

Try

=IF(I6="","",IF(INT(DATEDIF(I6,TODAY(),"m")/12)=0,"",INT(DATEDIF(I6,TODAY(),"m")/12)))

VBA Noob

[Ltat42a]

No...that didn't work, cell still shows blank (Excel 2003).

That's ok....gonna use conditional formatting to highlight that cell
in the case where the promotion date is entered.

Thanx for the help.

Lt

[VBA Noob]

Sorry,

Should of being

=IF(I6="","",IF(INT(DATEDIF(I6,TODAY(),"m")/12)=0,"0",INT(DATEDIF(I6,TODAY(),"m")/12)))

VBA Noob