How to test text string to know if it is a date

[itarnak]

I want to make a boolean function (isDate) to test if the text in a cell is a date or a simple text (comments or other)

How to do that?

Thanks

iTarnak

[Gary''s Student]

Today is your lucky day!! The IsDate() function already exists in VBA.
--
Gary's Student


"itarnak" wrote:

>
> I want to make a boolean function (isDate) to test if the text in a cell
> is a date or a simple text (comments or other)
>
> How to do that?
>
> Thanks
>
> iTarnak
>
>
> --
> itarnak
> ------------------------------------------------------------------------
> itarnak's Profile: http://www.excelforum.com/member.php...o&userid=27865
> View this thread: http://www.excelforum.com/showthread...hreadid=474094
>
>

[Gary''s Student]

However, if you want to use IsDate on the worksheet (rather than VBA) then
use a UDF like:

Function isdt(r As Range) As Boolean
isdt = IsDate(r)
End Function
--
Gary's Student


"Gary''s Student" wrote:

> Today is your lucky day!! The IsDate() function already exists in VBA.
> --
> Gary's Student
>
>
> "itarnak" wrote:
>
> >
> > I want to make a boolean function (isDate) to test if the text in a cell
> > is a date or a simple text (comments or other)
> >
> > How to do that?
> >
> > Thanks
> >
> > iTarnak
> >
> >
> > --
> > itarnak
> > ------------------------------------------------------------------------
> > itarnak's Profile: http://www.excelforum.com/member.php...o&userid=27865
> > View this thread: http://www.excelforum.com/showthread...hreadid=474094
> >
> >