Thanks chip - figured it out - function is a little different and reversed
in excel....
DateDif (start date, end date, "m")
"Chip Pearson" wrote in message
...
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)