How to use the function to start count the "text" if it start to appear in the cell

Hello,

How are y'all doing?

I needs help on the excel function, as i want to know is there a way to start count if the text "PS" appear on the cell and it consistency for 45 "PS". I have a spearsheet that have the employee timesheet for the whole year and i want to know if he work (working = PS, V = vacation) PS and if he consistency working for 45 days, if he skip a day in between then the statement will be false and it needs to count again if the next "PS" appear.

Is it possible ?

I attached the sample of the spreadsheet.

Thank you

Hi Robert,

Thank you.

I have couples questions, on this function
1. I needs to know if 1st "PS" appear, does it consistency for 45 days - result "True or False". If not then the next "PS" appear again does it consistency for 45 days - result "True or False"

2. Can the formula on another spreadsheet ?

Thank you