Rounddown Dates
 

Hello. I have a ROUNDDDOWn question with dates
Cell C8 = 2/1/04
Cell D8 = 2/28/08
The difference between the two when I enter ((YEAR(D10)-YEAR(C10)) is 2
years. In actuality, it's 20 months, but is rounding up to 2 years. I need it
to round down to 1 year. How do I use the ROUNDDOWN function with dates?

Rounddown Dates
 

=DATEDIF(C5,C6,"y")

Assuming c5 has 2/1/04 and c6 gas 2/28/08 this will round down for you
Note in your exampel the difference is 4+ years

"Micki" wrote:

Hello. I have a ROUNDDDOWn question with dates
Cell C8 = 2/1/04
Cell D8 = 2/28/08
The difference between the two when I enter ((YEAR(D10)-YEAR(C10)) is 2
years. In actuality, it's 20 months, but is rounding up to 2 years. I need it
to round down to 1 year. How do I use the ROUNDDOWN function with dates?

Rounddown Dates
 

Perfect! Thanks.

"Brad" wrote:

=DATEDIF(C5,C6,"y")

Assuming c5 has 2/1/04 and c6 gas 2/28/08 this will round down for you
Note in your exampel the difference is 4+ years

"Micki" wrote:

Hello. I have a ROUNDDDOWn question with dates
Cell C8 = 2/1/04
Cell D8 = 2/28/08
The difference between the two when I enter ((YEAR(D10)-YEAR(C10)) is 2
years. In actuality, it's 20 months, but is rounding up to 2 years. I need it
to round down to 1 year. How do I use the ROUNDDOWN function with dates?