Rounddown Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=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
 
Perfect! Thanks.

Brad said:
=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
Click to expand...
 
Back
Top