0.4 C
London
Friday, March 14, 2025
HomeSoftware TutorialsExcelHow to AutoFill Dates in Excel (3 Examples)

How to AutoFill Dates in Excel (3 Examples)

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

Often you may want to autofill dates in Excel. Fortunately this is easy to do using the simple drag and fill feature built into Excel.

The following examples show how to autofill dates in Excel in practice.

Example 1: AutoFill Days in Excel

To autofill a list of days in Excel, simply type in one date to start:

Then hover over the bottom right-hand corner of the cell until a tiny “+” appears.

Then click and drag down to however many cells you’d like in the same column:

The result is a list of consecutive days.

Example 2: AutoFill Weeks in Excel

To autofill a list of weeks in Excel, simply type in two dates that are exactly one week apart:

Highlight cells A2 and A3. Then hover over the bottom right-hand corner of cell A3 until a tiny “+” appears.

Then click and drag down to however many cells you’d like in the same column:

The result is a list of consecutive weeks.

Example 3: AutoFill Months in Excel

To autofill a list of months in Excel, simply type in two dates that are exactly one month apart:

Highlight cells A2 and A3. Then hover over the bottom right-hand corner of cell A3 until a tiny “+” appears.

Then click and drag down to however many cells you’d like in the same column:

The result is a list of consecutive months.

Additional Resources

The following tutorials explain how to perform other common operations with dates in Excel:

How to Use COUNTIFS with a Date Range in Excel
How to Calculate Average If Between Two Dates in Excel
How to Calculate the Difference Between Two Dates in Excel

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories