Cleaner formula for subtracting a set amount from a column of values each calendar day in google sheets? -

formula: in cell a1 manually type date i'm adding new value, in cell b1 have today() formula, , in cell c1 have formula =yourstartingvalue - (5*(b1-a1)).

result: end result value input cell c1 gets 5 subtracted each new calendar day. repeat step in new row each new value add.

my question: there formula can use don't have add stuff in a1 , b1 each time? it'd save time , make things cleaner. thanks!

in order have 5 subtracted every value in column every day, use script such one:

function subtractdaily() {   var sheet = spreadsheetapp.getactivespreadsheet().getsheetbyname('sheet1');    var range = sheet.getrange('c:c');   var values = range.getvalues();   range.setvalues(values.map(function(row) {     return [row[0] == parsefloat(row[0]) ? row[0] - 5 : row[0]];   })); } 

change sheet name , column needed, , set run daily using "resources > current project's triggers" dialog of script editor.

the script checks cells contain numbers , not attempt subtract 5 text or blank cells.