How to make RANDBETWEEN function triggered by date?

Question

Google Sheets

Is it possible to have the RANDBETWEEN function change value only by date, such as once a day or once a month?

Answer 1

The formula to implement this process will require iterative calculations and a very complex formula.
Try using a trigger on a function generateValue:

function generateValue() {
  var spreadsheet = SpreadsheetApp.getActive();
  var from = 1;
  var to = spreadsheet.getRange('Sheet1!C5').getValue();
  var rand = randBetween_(from, to);
  spreadsheet.getRange('Sheet1!D5').setValue(rand);
}


function randBetween_(from, to){
  return Math.floor(Math.random()*(to - from + 1) + from);
}

The original solution contains a similar problem, only the first value fromfor randBetween_ equals 1, and the second tois taken from the Table. The trigger is configured in such a way that the data in the cell is D5updated periodically.