I have found a similar question here:  

[How to make Google Sheet jump to today's column when opened?](https://webapps.stackexchange.com/questions/91944/how-to-make-google-sheet-jump-to-todays-column-when-opened)

I want to do a similar thing, but I have the dates in row 5 not in the column. I tried several times to make it work by doing some changes, either in the first than in the second script, but it didn't work. I'm really new, so I suppose the solution is easy, but unfortunately, I am not able to solve it by myself.

The code in the question I quoted is this:

```
function onOpen() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getActiveSheet();
    var range = sheet.getRange("A:A");
    var values = range.getValues();
    var day = 24*3600*1000;
    var today = parseInt((new Date().setHours(0,0,0,0))/day);
    var ssdate;
    for (var i=0; i<values.length; i++) {
        try {
            ssdate = values[i][0].getTime()/day;
        }
        catch(e) {
        }
        if (ssdate && Math.floor(ssdate) == today) {
            sheet.setActiveRange(range.offset(i,0,1,1));
            break;
        }
    }
}

```

Please, can someone help me?