Google-sheets – Lock a Google Sheet after 00:00

Yes. It is Possible. Just follow some simple steps:

1. You create a custom function by writing scripts which will work like simple function inside a Spreadsheet cell for ex: =SUM(A1 +A2) by Opening the Google Spreadsheet(That acts like directory ie. Data like name,contacts etc) ->Click Tools->Click Script Editor...

A new window will openup and choose spreadsheet option .Here,you can write custom functions which looks like

Here you write functions (for more info,https://developers.google.com/apps-script/your_first_script#requirements)

2.You create a function that will open your Spreadsheet that contains behaves like directory. A sample function

function readRows()
{
var sheet = SpreadsheetApp.openById("0AszINz88nA9hdEkxa1FIS0wta1FLS2NPUzAyU0lOV1E")
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();
var values = rows.getValues();
for (var i = 0; i <= numRows - 1; i++) { var row = values[i]; Logger.log(row); } };

For more info,https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#open(File)

You can Run and Test by pressing Run and selecting function, (it may require permission).

You can view the results in Log Window by Opening View->Logs.

That,it now you can use that function in that cell.

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.

• Solution

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.