Tuesday, August 28, 2007
Dealing With Unusual Date Formats
I’m sure that you have all been through this: You go to a Website (or a database, probably from a mainframe) to get some data. The problem is that the dates are formatted in some obscure way that Excel doesn’t understand. In this post, I’ll give you an idea of how to convert these dates into something that you can work with.
Yesterday I was working on a project that involves charting some economic data series. Frequently, charts of economic time series show shaded areas that indicate a period of recession (I’ve got a post that shows how to do that). So, I needed to know the dates for
Posted by Tim on 08/28 at 02:57 AM in
Dates
in
Economic Data
in
Excel
in
Functions
in
Date Functions
in
Date
in
EOMonth
in
String Functions
in
Find
in
left
in
len
in
mid
in
right
in
Search
Comments (2) • Permalink • Tell-a-Friend
Comments (2) • Permalink • Tell-a-Friend
Page 1 of 1 pages
