All Collections
Team Managers
How to change the date formatting in Excel
How to change the date formatting in Excel

When uploading your schedule, the date format must be DD/MM/YYYY

Updated over a week ago

Our schedule uploader is a little picky, and we plan to completely revamp it in order to make it easier to use. Until that time, please make sure that your date format is in DD/MM/YYYY format.

In order to change this in Excel, follow these steps:

  1. Select the date fields in Excel that you want to convert

  2. Right click and select "Format Cells"

  3. Make sure the "Number" tab at the top is selected

  4. Then click on "Date"

  5. Make sure you chose the 3rd option "14-03-2012" (see screenshot)

  6. Save the file as CSV

Did this answer your question?