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

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

Dave wrote:
>
> 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 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


"Dave" wrote:

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