How can I reference a cell in datevalue?

[Caleb]

When I try to reference a cell that has a date in date value the result
always comes up as #VALUE. Does anybody know how to fix this?

[Biff]

Hi!

DATEVALUE converts a TEXT representation of a date into a numerical value
that is a true Excel date.

If you enter a true Excel date in a cell the true underlying value is
numeric. Since DATEVALUE requires a text string as an argument the numeric
value (true Excel date) results in an error.

Maybe you should post a better explanation of what you're trying to do.

Biff

"Caleb" <Caleb@discussions.microsoft.com> wrote in message
news:71C79554-055D-45F4-A18C-85AA6AFADCBC@microsoft.com...
> When I try to reference a cell that has a date in date value the result
> always comes up as #VALUE. Does anybody know how to fix this?