Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

2 Answers 2

up vote 3 down vote accepted

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

http://docs.google.com/support/bin/answer.py?answer=82712&version=static#section_Date

share|improve this answer

For todays date, you can use the following formula.

Formula

=TODAY()

Explained

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.

Note

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

Reference

  1. TODAY
  2. NOW
share|improve this answer

Your Answer

 
discard

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.