Re: datevalue
- From: LarryTheK <LarryTheK@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 21 Jul 2005 16:04:01 -0700
"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
.
- References:
- datevalue
- From: LarryTheK
- Re: datevalue
- From: Govind
- datevalue
- Prev by Date: Re: Custom Cell Format Will Not Save Correctly
- Next by Date: Re: How can I show the total sum of items in a filtered column
- Previous by thread: Re: datevalue
- Next by thread: Re: datevalue
- Index(es):
Relevant Pages
|
