date query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hilton - 20 Nov 2007 09:49 GMT

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

Reply to this Message

Mike H - 20 Nov 2007 10:02 GMT

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

> 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

Reply to this Message

Hilton - 20 Nov 2007 10:42 GMT

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?

> Hi,
>
[quoted text clipped - 17 lines]
> >
> > eg 2007-06-19 and 1995-09-01

Reply to this Message