Return to Excel Formulas List

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

Download Example Workbook

Download the example workbook

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

auto populate dates


Insert Date Shortcut

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

insert date shortcut

This will hard-code today’s date.

TODAY Function

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



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:

auto populate date list

Google Sheets Populate Dates

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