date query

[Hilton]

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

 

[Guest]

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]

Hi,

The dates are in a text file. There are no dates in the worksheet. The VBA
code can read the date strings but how do I convert them to an acceptable
date format?