DateDifference Question

J

Junior

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)
 
C

Chip Pearson

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
 
J

Junior

Thanks chip - figured it out - function is a little different and reversed
in excel....

DateDif (start date, end date, "m")
 
Top