Hi,

I'm not exactly sure whether you mean VB or a worksheet function so here's
both. With the earlier date in A1 and the later date in A2 formatted as you
dexcribe right click the sheet tab, view code and paste this in:-

Sub sonic()
MyDifference = DateDiff("M", Range("A1").Value, Range("A2").Value)
End Sub

Or as a workshet function

=DATEDIF(A1,A2,"m")

Mike

"Hilton" wrote:

I have dates in the format yyyy-mm-dd. How do I get VB to convert these into
date format? I want to use the dates in a calc to determine the number of
months between 2 dates

eg 2007-06-19 and 1995-09-01