Function to return value based on conditions

[ahmadjumaa80]

Hi
currently, I am using google sheet
I want to use a function to satisfy the following conditions.

1. the values of cells range A3:L19.
2. the values of cells range A1:L1.
3. the values of cells range A22:L22.

if there is data (Text OR Number value) in the range (A3:L19) 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 occurring update) which is a value from the range (A2:L2)
in this case; it should be the last date of update 16/10/2024
Explain the idea
Thanks.

Also asked here Return one value from a range based on three conditions