Hi all. I'm trying to find the number of 'years' and 'months' between two dates. I used the DateDiff function however, the 'months' isn't showing exactly how I had planned.
My formulas are:
DateDiff("yyyy", #09/17/2009#, #06/07/2004#) and
DateDiff("m", #09/17/2009#, #06/07/2004#)
I'm getting "5 years" and "63 Months". Would really like to see "5 years" and "3 months".

Is there trick to this, or do I have to subtract the 'years' x 12 from the 'months' calculation?

Thanks