Auto Populate Dates (Automatic Dates) in Excel & Google Sheets

This tutorial will demonstrate how to automatically populate dates in Excel & Google Sheets.

Insert Date Shortcut

To insert today’s today, use the shortcut CTRL + ;.

This will hard-code today’s date.

TODAY Function

To create a formula that will calculate today’s date, use the TODAY Function:

=TODAY()

This formula will recalculate whenever formulas recalculate.

List Dates

To create a list of dates, first type your start date. Then click and drag the bottom-right corner of the cell to populate your list:

Google Sheets Populate Dates

Each of the above examples works exactly the same in Google Sheets as in Excel.