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! |
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! |
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! |
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 |
All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com