Working with dates

S

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!
 
G

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,
 
R

Ron Rosenfeld

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!
Click to expand...


=--(RIGHT(A1,10)

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

or

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


--ron
 
Top