| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using ROUNDDOWN - Help please | Excel Discussion (Misc queries) | |||
| rounddown | Excel Worksheet Functions | |||
| ROUNDDOWN Excell function | Excel Worksheet Functions | |||
| Rounddown problem... | Excel Discussion (Misc queries) | |||
| Roundup or rounddown | Excel Worksheet Functions | |||
Linear Mode
