0
So, I recently ran into an issue with a customer where a column (END DATE) was formatted to be a date using the (Format Cells, Date, Type "DD-MMM-YY"), but when a user was typing in a date, they entered (1 Mary 18), accidentally adding an "r" to may. The spreadsheet accepted this, and the user moved on, not noticing the error. This simple fat-finger wrecked all of the dependent cells and caused big problems, resulting in "#value" being displayed and the automation of the worksheet totally failing. Of course upon review I found the error, but as this worksheet grows, it will become increasingly more time consuming to find something like this (needle in a hay stack)
I'm certain there is a way to poka-yoke this through custom Data Validation, but I have not been able to figure it out. Any help would be much appreciated.