Hi, I have exactly the same problem, it seams like DATEDIFF only returns years difference in VBA for mac!

Sub test()
Dim dif As Integer
date1 = [b16]
date2 = [b17]
dif = DateDiff("yyyy", date1, date2)
End Sub


Unfortunately what I need is months difference, and when i use:

Sub test()
Dim dif As Integer
date1 = [b16]
date2 = [b17]
dif = DateDiff("m", date1, date2)
End Sub

or

Sub test()
Dim dif As Integer
date1 = [b16]
date2 = [b17]
dif = DateDiff("d", date1, date2)
End Sub

I also get years difference!!!

Please help!!!!

Jorge Jaime