I think the iserror function will work. =ISERROR(DateValue("12/32/1950")) should be TRUE
--- In ExcelVBA@yahoogroups.com, "Robert E. Carneal" <kentuckygenealogist@...> wrote:
>
> *Obviously, a date such as Feb. 31, 1705 cannot be correct. Can I have
> Excel "detect" invalid dates? Unfortunately, yes, most are before 1900. I
> just read XDATE information hoping to see a way to utilize XDATE into
> checking for a valid date, but didn't see one.
>
> Invalid dates play havoc on date calculations, so if I can detect it before
> calculation, I can force the user to enter a correct date.
> *
> *Thank you.
>
> **Robert*
> *Genealogy without documentation is mythology! Always SOURCE your work.*
>
>
> [Non-text portions of this message have been removed]
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar