The problem with using the UDF in the VALID()is that is never hits this code. The On ReadError fires first. Therefore, I do not understand how the date+100 years could work.