Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

converting to regular date format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Freida - 22 May 2008 14:22 GMT
I have 3 columns containing month (entered as january, february,etc), day of
month, year(2007,2008,etc).  I would like to create a column with the date in
regular date format (2/1/07).
Do I have to use some form of VLOOKUP together with the DATE function?
Gary''s Student - 22 May 2008 14:29 GMT
In cell D1 enter:
=DATEVALUE(B1 & A1 & C1)
and format as date
Signature

Gary''s Student - gsnu200787

> I have 3 columns containing month (entered as january, february,etc), day of
> month, year(2007,2008,etc).  I would like to create a column with the date in
> regular date format (2/1/07).
> Do I have to use some form of VLOOKUP together with the DATE function?
JLatham - 22 May 2008 14:43 GMT
I believe that Gary''s Student's response is probably the simplest and
easiest way to do this.  But I'll offer another way just because sometimes
options are nice to have.

Begin by creating a list of months.  I put mine in J1:J12.  Spell the months
as you will in your months column.  Then in the column where you want to show
the date as a date, use this formula (assumes we're working in row 1)

=DATE(C1,MATCH(B1,J$1:J$12,0),A1)

I think this is the kind of thing you had in mind that led you to the
VLOOKUP() part of your question.  VLOOKUP() isn't needed, the MATCH()
accomplishes the same thing using only 1 column instead of 2.  But again,
Gary''s Student's response is much more straight forward and probably more
understandable when you come back to see what it does later, plus doesn't
require the extra column of data.

> I have 3 columns containing month (entered as january, february,etc), day of
> month, year(2007,2008,etc).  I would like to create a column with the date in
> regular date format (2/1/07).
> Do I have to use some form of VLOOKUP together with the DATE function?
Freida - 22 May 2008 22:57 GMT
Cool.  I used Gary's straightforward method.  But I appreciate the extra
knowledge you provided me with, JL.  You guys are great.  Thanx
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.