Formula help - change date format based on drop-down selection in another column

gjohnson.pcpro

Hello all!

I have a sheet that is being used by people in the US and the UK. Users have requested that the date fields for their projects be formatted according to whichever region they're located in.

I have a column named "Region" where they select a drop-down with values of US and UK and then multiple date fields on the same row that the user must fill in for each project.

If the user chooses US in Region @row, I would like the date fields in the row to be formatted as MM/DD/YYYY. If the user choses UK in Region @row I would like the date fields in the row to be formatted as DD/MM/YYYY.

Does anyone know how I can accomplish this?

Jeremy_D

Hi, I'm pretty sure that the dates presented are based on the individual users regional preferences which they choose in their settings:

Unless you've found that this isn't the case?

Jeremy_D

Hi, I'm pretty sure that the dates presented are based on the individual users regional preferences which they choose in their settings:

Unless you've found that this isn't the case?

gjohnson.pcpro

Hah, you're absolutely right, Jeremy! For some reason the UK users settings were set up as English (United States). I just tested it by having them change their settings and that worked perfectly. Thank you!