Copy Date to Next Cell Automatically

Google Sheets: Auto-move today’s visit date from Next Visit to Last Visit (Apps Script + daily trigger) Copy Code: https://bettersheets.co/snippets/copy-date-to-next-cell-automatically This video shows how to use Google Apps Script to automatically move a “Next Visit” date to a “Last Visit” column when the Next Visit date equals today. It walks through creating an Apps Script project, selecting a specific sheet, reading date values from a range like E3:E, normalizing dates by stripping time with setHours(0,0,0,0), looping through the rows, and when a cell’s date matches today, writing that date into column D and clearing the original cell in column E using clearContent. It then demonstrates running and authorizing the script, and setting a time-driven daily trigger in the Triggers menu to run the function once per day within a chosen hourly window, with notes on adjusting ranges, row offsets, and column numbers. 00:00 Auto Copy Visit Dates 01:15 Open Apps Script Setup 01:35 Select Sheet and Range 02:10 Compare Dates to Today 03:46 Move Date and Clear Cell 04:26 Run and Authorize Script 04:53 Create Daily Trigger 06:55 Customize Columns and Wrap Up