98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Convert dates to Serial
Convert dates to Serial
Resolved · Low Priority · Version 2007
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use Paint Brush to Format More than one CellTo copy a format to many cells or ranges |
