Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

See the functions TODAY() and NOW() From the Help:

NOW

Returns the computer system date and time. The value is updated when you recalculate the document or each time that a cell value is modified.

TODAY

Returns the current computer system date. The value is updated when you reopen the document or modify values in the document.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

See the functions TODAY() and NOW()
From the Help:

NOW

Returns the computer system date and time. The value is updated when you recalculate the document or each time that a cell value is modified.

TODAY

Returns the current computer system date. The value is updated when you reopen the document or modify values in the document.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.