Count Consecutive Days Worked by an employee

  • Hi,


    I am stuck with a situation with Excel formula, I need to calculate how many days in a row someone has worked, it should not be more than 16 days in a row (inclusive of both day and night shift), otherwise highlight this, and also how many consecutive night shifts someone has worked, it should not be more than 7 nights in a row, otherwise highlight this.


    Help on this is greatly appreciated.


    Thank you.