Remember Me?

#1
November 21st 05, 06:00 PM posted to microsoft.public.excel.worksheet.functions
 Sandy Posts: n/a
Working with dates

Hello
Cell A1 contains the text The date is 2005-11-21. In B1 I would like
11/21/2005.
WHat formula should I use
Thanks!

#2
November 21st 05, 06:32 PM posted to microsoft.public.excel.worksheet.functions
 Gary L Brown Posts: n/a
Working with dates

=DATEVALUE(RIGHT(A1,LEN(A1)-12))
This will create the value of the date such as 38677 [Today].
Then format B1 however you want it to appear.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to

"Sandy" wrote:

Hello
Cell A1 contains the text The date is 2005-11-21. In B1 I would like
11/21/2005.
WHat formula should I use
Thanks!

#3
November 21st 05, 06:35 PM posted to microsoft.public.excel.worksheet.functions
 Gary''s Student Posts: n/a
Working with dates

Try:

=MID(A1,18,2) & "/" & RIGHT(A1,2) & "/" & MID(A1,13,4)
--
Gary's Student

"Sandy" wrote:

Hello
Cell A1 contains the text The date is 2005-11-21. In B1 I would like
11/21/2005.
WHat formula should I use
Thanks!

#4
November 21st 05, 08:23 PM posted to microsoft.public.excel.worksheet.functions
 Ron Rosenfeld Posts: n/a
Working with dates

On Mon, 21 Nov 2005 09:00:02 -0800, "Sandy"
wrote:

Hello
Cell A1 contains the text The date is 2005-11-21. In B1 I would like
11/21/2005.
WHat formula should I use
Thanks!

=--(RIGHT(A1,10)

with the cell formatted (Format/Cells/Number/Custom Type:
"mm/dd/yyyy"

or

=TEXT(--(RIGHT(A1,10)),"mm/dd/yyyy")

--ron

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mudgeman Excel Discussion (Misc queries) 2 May 15th 06 04:26 AM Danger Charts and Charting in Excel 2 September 20th 05 09:31 AM Pe66les Excel Worksheet Functions 3 August 25th 05 12:19 AM Phil kelly Excel Discussion (Misc queries) 2 June 21st 05 12:05 PM hjyoungii Excel Worksheet Functions 2 February 23rd 05 05:25 PM

All times are GMT +1. The time now is 03:30 AM.