Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like a certain cell of mine to display today's date when I starts a new row.

Is it possible?

share|improve this question
up vote 3 down vote accepted

You can use the =NOW() function inside that cell;


share|improve this answer

For todays date, you can use the following formula.




The TODAY() formula provides the current date with no time component. It's better to use that, than to use the NOW() formula. This will update on every edit made to the sheet, see reference.


Please realize that the value returned by the TODAY() formula isn't permanent.


  1. TODAY
  2. NOW
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.