Yes you would have unnecessary records, but they are only a couple of fields with ID numbers in, so it would depend on how many Employees you have, if it was thousands it would take a bit of space.

OK, that is a check that needs building in.

The On Change VBA would not be required.
It is odd because when using the original "On Change" code it will not allow a manual date entry, it triggers on the very first date character.

I will try coding in what we have discussed and see what you think of it, if that is OK?