"Govind" wrote:

Hi,

Try

=DATEVALUE("31-Dec-2005")

It works.

Your first two values were within single quotes and hence they wont
work. On the third format, am not sure of the reason why it doesnt work,
but your date format should be in sync with your default date format set
in the Regional settings.

Regards

Govind.

LarryTheK wrote:

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?


Sorry, it didn't help. Double quotes still give give the same error
message: Wrong data type.

I think the function is wrong.

Bottom line, I can't compute date differences to use in a formula.

LarryTheK