which returns the lowest Monday tide in the data, -0.64 To retrieve the date of the lowest Monday tide, the formula in I7 is: Where the worksheet contains the following named ranges: date (B5:B124), day (C5:C124), time (D5:D124), pred (E5:E124), tide (F5:F124). Both are array formulas and must be entered with control + shift + enter. Data from tidesandcurrents.noaa.gov for Santa Cruz, California. working from the inside out, the first IF checks if the day is “Mon”, based on the value in I5: If the result is TRUE, we run another IF: In other words, if the day is “Mon”, we check if the tide is “L”....