DateValue Giving everything but

[Dave]

Trying to get a DateValue from numerous dates. I've tried about every
format I can think of for the date field. When I do the fx for DateValue, I
get the function argument box, and when I select the date field (let's use
05/17/06), the Date_text line shows "=38854", but the 'Formula result ='
line at the bottom is blank When I click OK, the value appears as #VALUE.
But No DateValue.

I'm obviously missing something. Any suggestions would be appreciated.

MS Office/Excel 2003 SP2

Dave

 

[Dave Peterson]

=DateValue() converts text that looks like a date to a date.

It sounds like that field that contains 05/17/06 is already a date. If you just
use:

=A1
(if A1 contained 05/17/06)

Then you should see a date--you may need to format that cell with the kind of
date you want, though.

 

[Guest]

DATEVALUE only work on text dates, not 05/17/06! The whole point is to convert
text strings into dates like if you would have January in A1, 5 in A2 and
2006 in A3

=DATEVALUE(A1&" "&A2&", "&A3)

however the DATEVALUE function is totally obsolete, you can get the same
result with

=--(A1&" "&A2&", "&A3)



or

=0+(A1&" "&A2&", "&A3)

regards,

Peo Sjoblom