Fri 10 Jun 2011, 11:16
Edited on Fri 10 Jun 2011, 11:17Delegate Pedro said...
Pedro has attended:
Excel VBA Intro Intermediate course
Convert dates to Serial
Hello,
The Question:
How can I convert a date stored as string into a serial format?
Why I need it:
I found that to update the values of a pivot according to a date using VBA the date have to be in serial format.
I use this code to do that:
Workbooks(Name).Sheets("Zara").Range("G28").Value = PT.GetPivotData("Sum of Average", "Company", 1, "YearMonth", pivot_date).ValueI got the date as a string in a cell and I tried to conver it into serial using the Format function with 'c' but it didn't work
pivot_date=Format(str_date, c)There is other way to convert String Into Serial(date)?
Thanks,
Pedro F. Pardo
Tue 14 Jun 2011, 13:58Trainer Anthony said...
RE: Convert dates to Serial
Hi Pedro, thanks for your query. There is another way, you have to parse the text string and then use the DateSerial function. More information here...:
http://www.cpearson.com/excel/datetime.htm
...and here:
http://www.cpearson.com/excel/DateTimeVBA.htm
Hope this helps,
Anthony
