Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 21st 05, 05:00 PM posted to microsoft.public.excel.worksheet.functions
Sandy
 
Posts: n/a
Default 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   Report Post  
Old November 21st 05, 05:32 PM posted to microsoft.public.excel.worksheet.functions
Gary L Brown
 
Posts: n/a
Default 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
''''Was this Post Helpfull to you?".


"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   Report Post  
Old November 21st 05, 05:35 PM posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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   Report Post  
Old November 21st 05, 07:23 PM posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to find the working days difference between to dates? Mudgeman Excel Discussion (Misc queries) 2 May 15th 06 04:26 AM
Line Chart with dates in 5 day working week only Danger Charts and Charting in Excel 2 September 20th 05 09:31 AM
working with dates Pe66les Excel Worksheet Functions 3 August 25th 05 12:19 AM
working with dates Phil kelly Excel Discussion (Misc queries) 2 June 21st 05 12:05 PM
Is there a way to calculate business working days between dates i. hjyoungii Excel Worksheet Functions 2 February 23rd 05 04:25 PM


All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017