insert a value in a cell based on certain criteria in an attendance excel sheet

hi.
I am trying to put together a attendance sheet for work.. it has a column for name, a column for phone numbers and a row with numbers from 1 to 31 for each day.
it take mobile numbers as identification and just the date i.e 12 for 12/3/2015 and puts a P for present in the column with the date as 12
so if i put my phone number and date as 12. it will mark me present for work on that date
Problem: it identifies and finds the phone number correctly but for the date it selects the cell with the date as header and not to the one in the same row as the mobile number.
it should select the cell in the same row as the number below the date enetered e.g. 12. and the date will always be current day (today)
i am attaching an image of the sheet to give u a better idea..
Any Help will be greatly appreciated
Thnx

Please Login or Register  to view this content.

Attachment 386283attendance-sheet-eg.png