Rounddown Dates

M

Micki

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?
 
B

Brad

=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
 
M

Micki

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Difference in Complete Tax Years 1
Reverse Index Match 2
Calculating time between mulitple dates 4
Cumulative formula for word table 0
Adding dates in a IF Statement 2
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
Check if a date comes before/after a range of dates 0
I am attempting to find the difference between two dates... 2

Top