Get date function?

G

gb_S49

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?
 
J

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
 
R

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?
 
M

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