If B2 already contains a date, use it as is:

=B2

DATEVALUE will only convert Text. I assume by "won't work" you mean you
get the #VALUE! error, which indicates you're trying to convert numbers
or text that can't be interpreted as a date. If that's not the case,
please post back stating what "won't work" means.


In article ,
"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!