Changing Date Formats for non-US users

Google Sheets Show & Tell
, , ,
6

Hi @alyssa

Here’s one option for your new column C that will populate the column automatically with the dates in column B, but with a new Australia format. This should also transform dates for new transactions going forward.

  1. Create a new column C
  2. Add this formula in the first (header) row

=Arrayformula(IF(Row(C:C)=1,“MM/DD”,$B:$B)).

(Of course, you can replace MM/DD with another name of your choice.)

  1. Format the new column C with the modified DATE/TIME option of your choice.

This creates an automated transformation of your date data in a format you can use.

Will that work?