MAX DATE FROM 3 COLUMNS
On a separate sheet I would like to capture the max (or last) date from another sheet. As shown below, I would like to log the latest "DATE OF VISIT" from the 3 treatment columns. In this example the correct date would be 9/06/23. I've tried multiple versions of MAX(COLLECT but am only getting the first date, not the latest.
Thanks for your help in advance.
Help Article Resources
Check out the Formula Handbook template!