How to make dates auto Populate AND change in Google sheets for each day

Asked Dec 07 '21 at 07:13

Active Dec 07 '21 at 20:19

Viewed 27 times

I wanted to know if there's a way to make auto-populate AND change dates for each day.

so for example:

Column A is logging info daily, I want column B to auto-populate with each entry in Column A and at 12AM, I want the date to change to the current date while Column A is still logging.

Is there any if condition I can use for this?

edited Dec 07 '21 at 20:19

player0

124,011
12
67
124

asked Dec 07 '21 at 07:13

Abdul Raffay

Sorry, I didn't understand what you mean. Can you give an example? – Mike Steelson Dec 07 '21 at 08:00
@MikeSteelson Im trying to say that if i enter anything in column A, I want the date to be entered automatically in column B, and on the next day, i want the date to change to the next day as well. – Abdul Raffay Dec 07 '21 at 08:33
@AbdulRaffay Use `=IF(A1<>"",Today(),"")` – Harun24hr Dec 07 '21 at 09:18
@Harun24HR yes, but this will also change the previous day's date. I want to log each day's data with its date, won't Today() change the previous day's dates as well? – Abdul Raffay Dec 07 '21 at 10:28
It sounds like you want to timestamp edits on ColumnA. You can refer to the [following question](https://stackoverflow.com/a/11464015/6908282) – Gangula Dec 07 '21 at 10:50
1

@AbdulRaffay Then you need script. – Harun24hr Dec 07 '21 at 11:03
possible only with script – player0 Dec 07 '21 at 20:19

How to make dates auto Populate AND change in Google sheets for each day

0 Answers0