"Biff" wrote:

Hi!

The WORKSHEET function DATEVALUE doesn't return that type of error.

Is this in some code?

Either way, you'll need to provide more details.

Biff

"LarryTheK" wrote in message
...
When I try to use the function DateValue, I keep getting an error message
of
"wrong data type". I've tried many ways of entering the date: '12/31/05,
'12/31/2005, "12/31/2005", but none seem to work.

This was okay last year, but recently I get the error messages. Can
someone
help?


Hey Biff,

Well my spreadsheet returns this error! And it isn't CODE that I know of.
I've tried entering all sorts of date formats and I still get the error
message: ....wrong data type.

I've set the column to "date" with mm/dd/yyyy as the format. I've input
dates using a leading apostrophy ('01/01/2005) which displays as a date and
doesn't "calculate" the division a "/" calls for). I've input dates using
straight 7/21/5 and had 07/21/2005 displayed because of the column format.
Also, used an input of
"07/21/2005". Even with the quotes, it doesn't work.

All of these give me a #Value! response in the cell and an explanation of
"...wrong data type."

I use this function in a calculation, but no more. Can't get the difference
between two dates to do an interest calc.

LarrryTheK