Saturday, 22 Jun 2024

Add the Current Date When Data is Added to a Cell(Dynamic) – Google Sheets

A common question among Google Sheets users is whether there is a way to automatically display the current date when a cell has data in it, without having to use Google Apps Script. Well, the answer is yes, and in this article, we will explore two powerful tools that can help you achieve this: NOW and TODAY.

Using NOW and TODAY in Google Sheets

The NOW formula provides a date and time stamp at the time of execution or when the NOW() function is entered into the sheet. On the other hand, the TODAY formula provides just the date at the time of execution or when the TODAY() formula is entered into the sheet.

Change the date when a cell is edited

But simply having the date or time stamp when the formula is entered may not be enough. We want the date or time stamp to update only when a user enters something in a cell. To achieve this, we can use an IF statement.

Here’s the formula:

=IF(A2="", "", TODAY())

In the IF statement, we check if cell A2 is empty. If it is, no date will appear. However, if it contains a value, then the current date will appear in the corresponding cell.

Tham Khảo Thêm:  The Password Game: A Joyous Challenge for Tech Enthusiasts

To apply this formula to multiple rows, simply drag the formula downwards. This way, when a user adds data to your sheet, the date will automatically update.

Visual Example

To better visualize how this works, take a look at the following example:

Current Date Added When Cell is Entered

A Warning on NOW and TODAY

It’s important to note that NOW and TODAY are dynamic functions. This means that they will constantly update. If you need to get the date or time of something without it changing automatically, check out our tutorial on adding the current date to a sheet as a static value.

Give it a try and see how these formulas can enhance your Google Sheets experience!

Did you find this tutorial helpful? If you want to upskill and become a pro at Google Sheets, check out my course, “Google Sheets: Learn the Essentials with Three Detailed Projects.” Sign up today and take your spreadsheet skills to the next level.