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

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

MAIN

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:

=TODAY()

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:

auto populate date list

Google Sheets Populate Dates

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

Google

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!