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

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
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.


AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List