THANKS MUCH!!!

"William Horton" wrote:

The DATEVALUE function requires that the data type of the argument you enter
to be a TEXT data type. Therefore, if you adjust your formula to the below
it should work for you.

=DATEVALUE(TEXT(B2,"mm/dd/yy"))

If 8/22/2004 is in cell B2 the above formula will produce an answer of 38221.

Hope this helps.

Thanks,
Bill Horton

"Carol" wrote:

I want to convert an entered date using the DATEVALUE funtion to a number.
EX: =Datevalue("8/22/2004") .. However, when I substitute "8/22/2004" for
a cell reference, it won't work. Ex: =Datevalue(B2)

Any ideas please? Thank you!