I have a lengthy spreadsheet, I need to find which of two dates is the closest to a third date.
As an example, in "T" I would like to return the date from either "R" or "S" that is closest to "M" (positive or negative difference).
As an example, in "T" I would like to return the date from either "R" or "S" that is closest to "M" (positive or negative difference).
Cell Formulas | ||
---|---|---|
Range | Formula | |
O19 | O19 | =IF(LEFT(N19,1)="Y","",(M19-TODAY())*-1) |
P19 | P19 | =IF(N19<>"","",IF(M19+10<TODAY(),"Expired",M19+10)) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
O2:O9463 | Cell Value | =10 | text | NO |
O2:O9463 | Expression | =AND(ISNUMBER(O2),O2>10) | text | NO |
P2:P9463 | Cell Value | contains "Expired" | text | NO |
P2:P9463 | Expression | =AF2=TODAY() | text | NO |