All the dates that are entered are formatted differently, which is why the DateValue function does not return the correct information...clearly no-one at the office has heard of standardization...