Thread: Rounddown Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Micki Micki is offline
external usenet poster
 
Posts: 38
Default 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?