testing a cell for a date value

Hi,

Is there a way I can test the contents of a cell to see if it is a date?

Thanks.

Hi!

You can use this:

=ISNUMBER(A1)

Dates are really just formatted numbers. So, a cell that contains a number
will also evaluate the same as a date entry:

7/15/2006
10

Using ISNUMBER, both will evaluate to TRUE. (provided that the DATE entry is
a real Excal date and not TEXT)

Biff

"Karen53" <Karen53@discussions.microsoft.com> wrote in message
news:A6AE4B78-1EE4-4A6D-A16B-3BA9CE42C5C2@microsoft.com...
> Hi,
>
> Is there a way I can test the contents of a cell to see if it is a date?
>
> Thanks.

thanks, Biff. The answer you gave me the other day helped a lot too.

"Biff" wrote:

> Hi!
>
> You can use this:
>
> =ISNUMBER(A1)
>
> Dates are really just formatted numbers. So, a cell that contains a number
> will also evaluate the same as a date entry:
>
> 7/15/2006
> 10
>
> Using ISNUMBER, both will evaluate to TRUE. (provided that the DATE entry is
> a real Excal date and not TEXT)
>
> Biff
>
> "Karen53" <Karen53@discussions.microsoft.com> wrote in message
> news:A6AE4B78-1EE4-4A6D-A16B-3BA9CE42C5C2@microsoft.com...
> > Hi,
> >
> > Is there a way I can test the contents of a cell to see if it is a date?
> >
> > Thanks.
>
>
>

You're welcome. Thanks for the feedback!

Biff

"Karen53" <Karen53@discussions.microsoft.com> wrote in message
news:F35E7C9B-6D6F-4DE3-B679-EF20C360C5BC@microsoft.com...
> thanks, Biff. The answer you gave me the other day helped a lot too.
>
> "Biff" wrote:
>
>> Hi!
>>
>> You can use this:
>>
>> =ISNUMBER(A1)
>>
>> Dates are really just formatted numbers. So, a cell that contains a
>> number
>> will also evaluate the same as a date entry:
>>
>> 7/15/2006
>> 10
>>
>> Using ISNUMBER, both will evaluate to TRUE. (provided that the DATE entry
>> is
>> a real Excal date and not TEXT)
>>
>> Biff
>>
>> "Karen53" <Karen53@discussions.microsoft.com> wrote in message
>> news:A6AE4B78-1EE4-4A6D-A16B-3BA9CE42C5C2@microsoft.com...
>> > Hi,
>> >
>> > Is there a way I can test the contents of a cell to see if it is a
>> > date?
>> >
>> > Thanks.
>>
>>
>>