Different Date Formats

Question

Dear all,

I have several Excel Input Sheets (roughly 30) from different countries which I am trying to aggregate.

Sadly I have the typical issue of different Date formats - namely three different types:

YYYY-MM-DD

DD.MM-YYYY

DD/MM/YYYY

I have already converted the second and third date format to a new column and do now have three columns which i want to aggregate to one:

Date_Okay

Date_Help_1

Date_Help_2

Each of the columns shows either the correct date or a [Null]

I now want to aggregate the three columns to one and thus elminating the [Null] values. I used the following formula which is not working:

IF [Date_Help1]!="Null" THEN [Date_Help1] ELSEIF [Date_Help2]!="Null" THEN [Date_Help2] ELSE [Date_Okay] ENDIF

Do you have an idea on how to solve this?

Thank you very much in advance!

Best regards, Alex

JosephSerpis · Accepted Answer

Hi @maier_alexander_MO try using this syntax . You want to use the test functions within the formula tool you can use a ! to test is not as well.

IF !IsNull([Date_Help1])THEN [Date_Help1]
ELSEIF !IsNull([Date_Help2])THEN [Date_Help2]
ELSE [Date_Okay] ENDIF