Hi!

Explain how you are using it.

Datevalue( ) takes a TEXT argument. If you try to use a numeric argument
you'll get #VALUE!.

Biff

"lmullenjr" wrote
in message ...

I am trying to use the Date Value function to convert a date to a
numeric value and I am getting #VALUE! error message. Any ideas why
this would be happening?

Drummer


--
lmullenjr
------------------------------------------------------------------------
lmullenjr's Profile:
http://www.excelforum.com/member.php...o&userid=33132
View this thread: http://www.excelforum.com/showthread...hreadid=529429