Forum Discussion
Solved
Get a value from Range
Hi Currently, I am using goole sheet. I need a function to get last date of update. Last date of update means the latest date from range (C7:H7) of the following conditions: the last column in t...
=ARRAYFORMULA(MAX(IF(C5:H5+C6:H6+C8:H8+(C9:H18<>""),C7:H7)))
=ARRAYFORMULA(MAX(IF(C5:H5+C6:H6+C8:H8+(C9:H18<>""),C7:H7)))
Many thanks
If there is no valid condition then the function return this date 12/30/1899, How to avoid it? I demonstrate that in the google sheet. see the link please
When there is no valid condition, the formula is returning false, means 0 (zero). In case of date type cells, 0 means 12/30/1899. To avoid this situation use custom cell formatting M/d/yyyy;;
