Get date function?
 

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?

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

-----Original Message-----
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?
.

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

"gb_S49" wrote in message
...
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?

That's brilliant..THANK YOU

"RagDyeR" wrote:

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

"gb_S49" wrote in message
...
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, It works.
That's brilliant.
THANK YOU
What does int mean though

"Jason Morin" wrote:

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

-----Original Message-----
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?
.

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))


"gb_S49" wrote in message
...
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