It would be easier to see your spreadsheet because I have no idea what a Survivor pool spreadsheet might look like. But my first thought would be each entry has a separate tab with two reference dates and if statements, or if it's all on one tab a "reference start" and "reference end" date and if statements.