I have extracted date values in
|1||date||time||year||date value||time value|
I am trying to create an array formula in AP2. For each row in
AM2:AO, CONCATENATE (or JOIN) the values in columns
AO and then pass that result into a DATEVALUE function.
Current formula in
AP2 that works for a single formula is:
I cannot apply this formula to the entire range using ARRAYFORMULA.
I've tried using CONCAT, JOIN, &, all without success.
Example of a formula that doesn't work:
=ArrayFormula(DATEVALUE(AM2:AM & AO2:AO))