=AND(
R14 <> "",
OFFSET(R14, 1, -1) <> "",
NOT(ISNUMBER(OFFSET(R14, 2, 0))),
OFFSET(R14, 1, 0) <> "R/O",
NOT(ISNUMBER(R16)),
R17 <> "R/O",
IF(R14 < OFFSET(R14, 1, -1),
ABS((R14 + 1 - OFFSET(R14, 1, -1)) * 24) < 12
)
)
10 in arow
=AND(COUNTA(OFFSET(W55, 0, -10, 1, 10)) = 10,
COUNTIFS(OFFSET(W55, 0, -10, 1, 10), ">0", OFFSET(W55, 0, -10, 1, 10), "<1") = 10,
COUNTIFS(OFFSET(W55, 0, -10, 1, 10), "<>0") > 0)
=IF(E4 < TODAY(), "Expired", IF(E4 <= TODAY() + 30, "Attention", "Current"))