increment a cell in google sheets each day
Clash Royale CLAN TAG #URR8PPP increment a cell in google sheets each day I have a script that needs to increment a cell every day. I have tried several methods comparing dates with the current date with the previous recorded date but that doesn't seem to work at all. I am recording the day each time there is an entry, which I was using to increment the cell, with the following var curDate = Utilities.formatDate(new Date(), "GMT-5", "MM/dd/yyyy") the last thing I did to compare them was the following: var today = parseInt(Utilities.formatDate(new Date(),"EST","D")); var lastRecordedDay = parseInt(Utilities.formatDate(new Date(SpreadsheetApp.getActiveSpreadsheet().getSheetByName("total").getRange(challegeDay,3).getValues()),"EST","D")); if (SpreadsheetApp.getActiveSpreadsheet().getSheetByName("total").getRange(challegeDay,3) < curDate.valueOf() ){ } but the output told me yesterday had a...