So, you’re totalling a formula up (such as a sum) and you do not want the value to display as 0 (i.e., zero). In my case, some people will use the spreadsheet online, while others will print it out. For those who print it, I want the total column to appear blank (but it is not!) so that they can manually print in their calculations (sure, they should be using it online, but….)
To display a blank value instead of zero, use this bit of code modified for your function (in my example, sum) and values (my case, a range of cells C3 throughH3):
Now, to add the date, each time a spreadsheet is opened or saved:
In a cell:
Ah, but you only want the year and month, e.g., June-01
Right click on the cell, format> on the number tab, choose> Date Now choose the date as you would like it to format. Need the time? Throw that in, too!