Adding a cell that is always todays date + 1 day

[libcach]

I am looking to create a cell that is always today’s date plus 1 day. Currently a method that arrives at the right result is a field of date in a cell, which automatically updates based on the computer clock. Then referencing that cell in the formula =DATE(YEAR(cell),MONTH(cell),DAY(cell)+1). This equals the correct value initially but does not update on subsequent opens of the file.

I am printing this file from the command line however, the field value does work for other documents I print this way that require the current date.

[Lupp]

“Always” may be impossible. Of course, the document must be open to get updated.
To get the cell containing the result automatically updated, AutoCalculate must be enabled and the cell needs to either reference a cell that got an update since the last midnight, or to call a volatile function itself.
I’m not sure if TODAY() itself is made volatile (as should be expected), but you can use NOW() e.g. like in
=TODAY()+1+NOW()*0 This will update under AutoCalculate whenever a cell is edited (the “+1” for the next day, the “*0” to annullate the returned value).
If your sheets don’t recalculate when opened/reloaded (or on Shift+Ctrl+F9) something is wrong with your install.

Quoting @libcach: “Currently a method that arrives at the right result is a field of date in a cell, which automatically updates based on the computer clock.”
This I don’t understand clearly. What method exactly? What “field of date”? How does your cell look to the computer clock? Why so complicated?

[libcach]

I have a cell that is inset → field → date. That always provides the correct date even when printed from the command line. However, it was simply the easiest solution that worked for other sheets for myself when getting the current date. The problem came with the formula I posted above not auto calculating. Which does seem to be configured correctly. What I mean by referencing the computer clock is if I manually change the date inset → field → date updated.

=TODAY()+1+NOW()*0 seems like a much better way to handle this and is working correctly. Thank you!

[mikekaganski]

If TODAY isn’t volatile, then =INT(NOW())+1 seems simpler and with slightly less overhead.

Just checked: as mentioned on TODAY’s help page, it is actually volatile; so simple =TODAY()+1 works nicely.