DateDifference Question

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

 

[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

 

[Junior]

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

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

 

[Guest]

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