مطالب مرتبط با «countif non consecutive columns» در back soft | نویسنده: استخدام کار
Counting non consecutive dates in Excel within a given range
Vote count: 0 I am attempting to make an excel sheet to track the number of times an individual is either late or gone for a period of time, consecutive days only counting as one infraction, in a rolling 12 week period. My thought is each time there is a break in the dates there is another infraction (Example: 1 jan, 2 jan, 5 jan), thus comparing adjacent cells to see if the dates are consecutive would be a way to count the number of time the individual was gone for any period of time. The end result I am aiming for is to have the individuals names down column A and just enter the date into the next column for every day that they are late or gone and have the number of infractions shown in a...
ادامه مطلب
