@ruth oh god I've been fighting with the google spreadsheets function about that all day (for non-work-reasons) because it literally doesn't comprehend that not everyone is american and thus not everyone does date formatting in month/day/year. i ended up having to strip out the date formatting entirely and just set it as plaintext because there's no way to make it stop - even if i custom-set it to do day/month/year, it assumes that my INPUT is in month/day and still changes it.