Make your Table structure like this
S.No | Name | Year | Month | D1 | D2 | D3 | D4 | D5 | D6 | D7 | D8 | D9 | D10 | D11 | D12 | D13 | D14 | D15 | D16 | D17 | D18 | D19 | D20 | D21 | D22 | D23 | D24 | D25 | D26 | D27 | D28 | D29 | D30 | D31 |
1 | CG | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
2 | JSOP | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
3 | Pete | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
4 | Nish | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
5 | Luc | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
6 | Sacha | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
7 | Dave | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
8 | DD | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
9 | Marc | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
10 | Chris | 2010 | 12 | P | P | P | P | P | P | P | P | P | A | P | P | P | P | A | A | A | A | A | P | P | P | A | P | P | P | P | P | P | P | P |
Now you can bring the things in front end by using Gridview control with templates.
Dynamically Templated GridView with Edit, Delete and Insert Options[
^]
You can use checkbox control in Grid view Item template for mark the the person whether Present or absent. Also Make S.No, Name, columns read only because you don't need to enter things in those fields. Also you can put the year & month in dropdownlist in Item template. Anyway Go ahead.
BTW check the things like Feb month total days(28 or 29 based on leap year).