Thread: Date Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Yossy Yossy is offline
external usenet poster
 
Posts: 127
Default Date Validation

Please I have thousands of rows across multiple columns. I need to validate
date in m/d/yyyy format. Coding will really help me as I use some formula
that does not help across multiple date. If possible to color any date not in
the m/d/yyyy format.

Sometimes I get error like d/m/yyyy or m/d//yyyy or d//m/yy or sept 2000.
Please help me be able to identify these date problem. Its really making me
get so many error files.

Thanks a big bunch!!