Your code should work in VBA the same way. E.g.,

Debug.Print DateDiff("m", #1/1/2004#, Now)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Junior" wrote in message
...
I want to compare two cells containing dates (beginning and
ending) and
return the number of months difference -
the purpose is to use this figure for computing annual
turnover.
I can't seem to get DateDiff calculation that works in Access
to work in
Excel
Help please

DateDiff("m",start, end)