Sorry, I ommitted something that was critical. The reason why I wasn't using a formula for this is becuase I need to be able to see past changes. So if someone cancels and then the next week activates and then puts it on hold I need to be able to see the status they were at during those payroll periods.

The formula works perfectly but it changes the past status which may or may not be accurate.

Does that make sense?