testing a cell for a date value

[Guest]

Hi,

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

Thanks.

 

[Biff]

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

 

[Guest]

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

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

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