Hi, Catherine. Maybe this function can help:
DATEADD([date], [#], ‘units’) Adds specified “count” units to a datetime.
DATEADD(Date, 10, ‘days’) => 10/9/2015 12:00am
Hi Matt. A quick thought… Maybe you could format your source file date field in the American way, export to your Csv, import to airtable. Airtable should treat your field as a date and not a text so you finally can change it to European format.