I need a function to return last date of update

there is another error #NAME?

Could you please write the function in the attached file

Sorry, ARRAYFORMULA instead of ARRAYFUNCTION

There is an error when applying this formula #NAME?

As far as I can tell:

=ARRAYFUNCTION(LET(n, MAX(IF((A3:L19<>"")+A1:L1+A22:L22, COLUMN(A3:L19))), IF(n=0, "", INDEX(A2:L2, n))))

HansVogelaar 

Hi
currently, I am using google sheet
I want to use your function to satisfy the following conditions. I think that your function or formula is needed to be modified. The new function should be compatible to  this case:

in the attached file, based on the following:

• the values of cells range A3:L19.
• the values of cells range A1:L1. 
• the values of cells range A22:L22.

if there is data (Text OR Number value) in the range (A3:L18) OR the values of range A1:L1 are equal to (True) OR the values of range A22:L22 are equal to (True).
I need a function to return one value from a range (the last date of update) which is a value from the range (A2:L2)
in this case; it should be the last date of update 16/10/2024
Thanks.

ajl_ahmed 

Try this instead (without -3):

=ARRAYFORMULA(LET(n, MAX(IF((A3:L19<>"")+A1:L1, COLUMN(A3:L19))), IF(n=0, "", INDEX(A2:L2, MAX(IF((A3:L19<>"")+A1:L1, COLUMN(A3:L19)))))))

ajl_ahmed 

Simply enclose the expression in ARRAYFORMULA( 😞

=ARRAYFORMULA(LET(n, MAX(((A3:L19<>"")+A1:L1)*COLUMN(A3:L19)), IF(n=0, "", INDEX(A2:L2, MAX(((A3:L19<>"")+A1:L1)*COLUMN(A3:L19))))))