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
Solved! Go to Solution.
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
Hi JS420,
thank you very much for your quick help on the below, that solved my problem!
Have a nice day and kind regards,
Alex