I have attendance file for employees with attendance marking as Present, P, Weekly OFf, WO and leave. At max, an employee is supposed to work consecutively for 6 days. One is not supposed to work on 7th day consecutively. How do I check if there is a 7th day working attendance? Start day 21st of previous month and end date is 20th of current month. Please check attached file.