date query
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 |
date query
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 |
date query
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? "Mike H" wrote in message ... 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 |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com