Pl help me with the formula to check the continous absent data in the attendance sheet where in the absence & present is mark in the attendance sheets datewise.
Scant on detail.
In the same vein:
You're making hard work for yourself; you don't need Sheet2 or helper columns, get the data directly from the Punching Data sheet where:
1. Pivot table taking 30 seconds to produce
2. Table at cell M1 showing consecutive absenteeism (assumes Sundays are to be ignored, so absence Saturday (,Sunday) and Monday = 2 days' continuous absenteeism.
Both tables need to be refreshed if the data in the source table is updated.