Is there an "ISDATE" type function in Excel

[ru4ward]

Is there any such function within Excel that will allow me to check for a date in a column that I can use.

I looking for something like the ISTEXT type command that would return a TRUE value if the condition of a date is returned.

If anyone else has a easy solution, I would appreciate it.

Regards

 

[burritron]

Re: Is there an "ISDATE" type function in Excel

Thank you so much! Was looking for this for a while.

Hi ru4ward:

As phantom1975 has delineated, ISDATE function is available in VBA, but not in native Excel. The following is a formula based approach to check whether the entry in cell B3 is a valid date:

'=IF(NOT(ISERROR(DATEVALUE(TEXT(B3,"mm/dd/yyyy")))),"valid date","invalid date")

Please post back if it works for you -- otherwise explain a little further and let us take it from there.