This sounds very similar to my solution, based on the the detail on the question, I have to make a few presumptions. My solution involves the following:
- I used Google forms, but the script works on the response spreadsheet so is applicable to your problem
A copy of the spreadsheet is made each day at a certain time using triggers** that activate the script, and the main sheet is cleared to make way for the new data for the next day. Before clearing the data from the response sheet, I have a copy of the sheet sent to a folder called folder 1.
So on any day when you open the spreadsheet you are only looking at the current day's data.
**Triggers: From the spreadsheet go to "Tools> Script editor" from the menu
In script editor: Go to "Resources>Current projects triggers" from the menu
Choose a time for the spreadsheet function (see link underneath for script) to copy and delete
Below is a link to my script. The problem I have at the moment is clearing the responses, but from your question, it sounds as though you are not using a form so my problem is not yours. The script will work for you
Google forms script to delete responses counter
I hope this helps.