When working with date columns in excel data sources you may notice that your dates appear as serial numbers instead of a human readable dates. This is because under the hood, excel stores all dates as number representing the number of days since January 1, 1900.

The simplest way to handle the way excel stores dates is to simply create a column in excel which converts the date into a human readable string. The formular below can be added as a new column in your excel table, and even be hidden by default. Once this column has been setup you can reference the text in this column within Team Forms.