DATEDIF function

[C.S.]

I need a datedif formula to look at the months and days between two dates and display only the months. However, i need the result (number of months) to be rounded up if the days are 15 or more and rounded down if 14 or less. right now i'm using this formula, but i'm not sure how or where to alter:
=DATEDIF(G6,H6,"y")&" years "&DATEDIF(G6,H6,"ym")&" months "&DATEDIF(G6,H6,"md")&" days"

also, is the datedif function a useable function in older versions of excel? (2003, xp, etc.) I'm using 2007.

thanks,
cs

 

[C.S.]

thanks barry, you did it again! how simple! I don't get it though, how does just the "+15" part effect it like it does? i.e. rounding up or down.

clint

 

[barry houdini]

It may not give the exact rounding you want (it depends on the month lengths) but DATEDIF effectively rounds the months down so if you add half a month to the latter date (or subtract half a month from the start date) then you'll virtually get what you want, i.e. rounding to the nearest month

It's just a little bit imprecise because, of course, 15 days is not always half a month, depending on the month in question.......

 

[C.S.]

the 14th and 15th are static regardless of the month so its no concern. awesome, thanks for the explanation.

thank you very much barry!

c.s.