- Registration date
- Sunday September 12, 2010
- Last seen
- August 5, 2021
Drag these two cells down as far as desired and change format to date.
This basically adds time to the date.
If you don't want that because of further calculations use another (temporary) column and use the INT formula as in: