I help run an underwater hockey club. To smooth administration I wanted to create an mobile application to record attendance and the payment of weekly subs.
After a bit of iteration this worked really well. This is what it looks like on the phone. You can see that I have frozen the first column so that it is easy to swipe to the date column your require. I have used Data Validation to constrain the cells to the range of values shown. When you tap a cell you are therefore give a dropdown list.
The file is on OneDrive and easily shared with others in the club. Excel on mobile is free (I think). The other sheets in the workbook are used for members’ registration details and to work out profit and loss etc.
If you have a nice application of Office on mobile please tell me in the comments.