Hey romperstomper, thanks for the quick reply!

The formula is being used on 'S1DAY P1(Ongoing)' Sheet