I am calculating the difference between dates, I first

calculate

days : datediff ("d", date1, date2) It gives me 48 days.

months: datediff("m", date1, date2) It gives me 2 months.

Should that say 1 month instead of two?

I can't seem to locate where I found some date functions that provided more

accuracy than the ones built into VBA, but you can try this (watch for line

wrap - it's all on one line):

datediff("m",Date1,Date2)-abs(dateadd("m",datediff("m",Date1,Date2),Date1)<Date2

)

This one was off the top of my head - I really haven't tested it thoroughly.