Working with dates

[Sandy]

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!

[Gary L Brown]

=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
gary_brown@ge_NOSPAM.com
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!

[Gary''s Student]

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!

[Ron Rosenfeld]

On Mon, 21 Nov 2005 09:00:02 -0800, "Sandy" <Sandy@discussions.microsoft.com>
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