| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Line Chart with dates in 5 day working week only | Charts and Charting in Excel | |||
| working with dates | Excel Worksheet Functions | |||
| working with dates | Excel Discussion (Misc queries) | |||
| Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
Linear Mode
