Hi,
Below is my sample data set. Question: How many consequtive Fridays and Mondays did Chris W take in the data set below? The answer is 4.
Criteria 1. Look at the Days column: Does Monday follow after Friday? If it does than count it, if it does not, don't count it.
Criteria 2. Is there a separation of 2 days between Friday and Monday? If yes,then count it, if there is more than 2 days, don’t count it.
Please see let me know if you could help me with this. I have also attached my sample spreadsheet. Thank you.
Data Sample:
Personnel Date Month Days
Chris W 5/10/2013 May Fri
Chris W 6/6/2013 Jun Thu
Chris W 6/13/2013 Jun Thu
Chris W 6/14/2013 Jun Fri
Chris W 6/27/2013 Jun Thu
Chris W 6/28/2013 Jun Fri
Chris W 7/12/2013 Jul Fri
Chris W 8/16/2013 Aug Fri
Chris W 8/19/2013 Aug Mon
Chris W 8/20/2013 Aug Tue
Chris W 8/30/2013 Aug Fri
Chris W 9/6/2013 Sep Fri
Chris W 9/20/2013 Sep Fri
Chris W 9/23/2013 Sep Mon
Chris W 9/27/2013 Sep Fri
Chris W 9/30/2013 Sep Mon
Chris W 10/25/2013 Oct Fri
Chris W 10/28/2013 Oct Mon
Bookmarks