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

Is it possible?


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


| 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
| improve this answer | |

As mentioned by @Jacob Jan Tuinstra, TODAY updates automatically (so does NOW) and as I don't see the value of an entire column within which each cell always shows the current date, I interpret the requirement to be for a non-volatile solution. Hence suggest:


in the cell starting a new row. For such cells to be populated with the same result automatically would require a script with an OnEdit trigger.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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