Safest way to capture a date in Excel
Safest way to capture a date in Excel.
If the dates in your spreadsheet were captured by a human typing, the biggest risk is lack of consistency. Even if an IT system is incorrectly creating the dates at least they will be consistent. Humans don’t mind if a column of dates looks like this
But Excel will not recognise all those dates. On my computer only the last one would be recognised as a date. There is a safe way to manually capture dates into a spreadsheet so that there is a 99% chance Excel will immediately recognise it as a date.
To see the full course contents click here.