Auto Populate Dates in Excel (Automatic)

This tutorial will demonstrate how to insert dates automatically into Excel.


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.