Get date function?

[Guest]

I am trying to extract just the date aspect of the following (text?) (cell A3)
30/03/2005 14:17:00. using =DATEVALUE(MID(A3,0,10))
all i get #value
any suggestions?

 

[Jason Morin]

Use

=INT(A3)

if it truly is a date, and format the cell as date. If
it's a text string, try:

=LEFT(A3,FIND(" ",A3)-1)+0

HTH
Jason
Atlanta, GA

 

[RagDyeR]

Try these:

Put this in a cell:
=A3
And format the cell
dd/mm/yy

OR
Put this in a cell:
=TEXT(A3,"dd/mm/yy")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am trying to extract just the date aspect of the following (text?) (cell
A3)
30/03/2005 14:17:00. using =DATEVALUE(MID(A3,0,10))
all i get #value
any suggestions?

 

[Guest]

That's brilliant..THANK YOU

 

[Guest]

Jason, It works.
That's brilliant.
THANK YOU
What does int mean though

 

[Myrna Larson]

In case you are wondering why your formula didn't work, it's because
characters are counted starting with 1, not 0. It should be

=DATEVALUE(MID(A3,1,10))