Does B2 contain a text representation of a date, or the date itself?

Sounds like it's the date itself, in which case you can simply refer to the
cell itself (i.e., =B2) as it is already a date serial number.


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