Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Nov 03, 2024

I need a function to return last date of update

Hi
I need a function to do this case:

in the attached file, based on the values of cells range A3:L19 and the values of cells range A1:L1; if there is data (P OR Number value from (1 to 5)) in the range (A3:L18) or the values of range A1:A18 are equal to (True), I need a function to return the last date of update which is a value from the range (B2:B18) in this case; it should be the last date of update 16/10/2024
Thanks.

 

Resources