You can also use the "Date" function. Just insert function "Date" and enter the date you want. When you copy/paste the date remains unchanged.