Auto populate field from multiple columns

[5arahlou]

Hi,

I cant for the life of me find a formula to 

I have 3 date columns in each record, only one of these will be populated per record, i want to create an additional single column which would auto populate with the date from either of these 3 fields so i can format it to a week number (and YY of possible).

Is this possible to do and if so can anyone help with the formulae for this please?

Thank you so much, Sarah 🙂

[TheTimeSavingCo]

Try:

DATETIME_FORMAT(
  {Date 1} & {Date 2} & {Date 3},
  "WW YYYY"
)