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)

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)

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)

use DateAdd function to accomplish your task (it does subtractions too)