How should I enter dates in TTI worksheets?

Andrew Skujins -

In Excel, date formats are specified by the host operating system (e.g. Windows).

The Windows defaults do not correspond to Canadian/CRA/worldwide standards (ISO 8601). Short dates are recommended to be set as "yyyy-mm-dd".

Control Panel > Region and Language  > "Short date:"


Have more questions? Submit a request


Please sign in to leave a comment.