Yes. In Excel for Microsoft 365 on Windows, enter a starting date and drag its fill handle down or across to continue a daily sequence; select two dates first if you want Excel to detect a different interval. For more control, use Home > Fill > Series, or enter a date formula such as =A2+1 and fill it down.
How Excel date autofill works
Excel stores dates as serial numbers, so a calendar date can be increased by adding a number. A daily sequence advances by one serial number per row; a weekly sequence advances by seven. The number you see in a cell is formatted as a date, but the underlying value is numeric. This is why Excel can extend dates as a pattern rather than treating them only as text.
When you drag the fill handle from one date, Excel generally continues with the next calendar day. When you select two dates before dragging, Excel uses the difference between them as the interval. For example, selecting January 5 and January 12 establishes a seven-day step, so the following dates are January 19, January 26, and so on. This is useful for weekly schedules and recurring reporting periods.
The small square at the lower-right corner of the selected cell or range is the fill handle. If you do not see it, check Excel’s settings: on Windows, open File > Options > Advanced and make sure Enable fill handle and cell drag-and-drop is selected. On a Mac, look in Excel > Settings (or Preferences, depending on the release) > Edit for the fill-handle setting.
Fill a daily date sequence with the mouse
- Enter a valid date in a cell, such as 1/5/2026. If Excel recognizes it as a date, it will normally display it in the workbook’s date format.
- Select the cell and point to its lower-right corner until the pointer becomes a small black plus sign.
- Drag the fill handle down or to the right for as many dates as needed, then release.
- Check the final cells. Excel should show consecutive days, including weekends.
If Excel copies the original date instead of advancing it, click the Auto Fill Options button that appears near the filled range and choose Fill Series. You can also start with two consecutive dates, select both, and drag the fill handle; the pair makes the intended one-day step explicit. On Windows and Mac desktop Excel, the basic drag-and-fill method is similar. Excel for the web also supports filling by dragging, though the available options and interface can differ slightly.
To fill a known number of rows without dragging, select the starting cell and the cells below it, then use Home > Fill > Down. This copies the top cell’s contents, so by itself it does not create a date series from a single date. Use it after entering a formula that refers to the previous row, or use the Series command when you need Excel to generate the dates directly.
Choose the interval: days, weeks, months, or years
Autofill can extend more than daily dates. The simplest way to teach Excel an interval is to provide two starting dates. Enter January 5 and January 12, select both cells, and drag; Excel extends weekly dates. Enter January 5 and January 19 to establish a two-week interval. The same principle applies to dates separated by a month or year, although dates near the end of a month can require extra care.
For a precise range, use the Series dialog. Enter a starting date, select the range to fill, then choose Home > Fill > Series. In the dialog, set Series in to Columns or Rows to match the direction of the selected range, choose Date under Type, select a Date unit, and enter a Step value. You can also enter a Stop value. For instance, a step of 7 with the Day unit creates weekly dates; a step of 3 with the Month unit creates quarterly dates. The result depends on the start date and the selected unit, so check the generated sequence, especially for month-end dates.
The Auto Fill Options menu that appears after dragging can also offer choices such as Fill Days, Fill Weekdays, Fill Months, and Fill Years. These options are helpful when the initial drag creates daily dates but the schedule should advance by a different calendar unit. If the menu disappears, undo the fill and repeat it, or use the Series dialog instead.
Use formulas for repeatable date sequences
A formula is often easier to audit than a long drag, especially when the dates need to update if the starting date changes. With the start date in A2 and the next date in A3, enter =A2+1 in A3 and fill it down. If A2 contains January 5, 2026, A3 returns January 6, 2026, and the row beneath returns January 7 when the formula is filled down. Because the formula refers to the cell above, each row advances one day.
For a weekly sequence, with the starting date in A2 and the next date in A3, enter =A2+7 in A3 and fill down. If A2 is January 5, the next result is January 12. Change 7 to another number to set a different number of days between dates. Format the result cells as dates if Excel displays serial numbers instead.
With Microsoft 365 or Excel 2021, the SEQUENCE function can spill a fixed number of dates into neighboring cells. To generate ten daily dates beginning January 1, 2026, enter =SEQUENCE(10,1,DATE(2026,1,1),1) in an empty cell such as A2. It returns ten consecutive date serials in A2:A11; format that range as dates to display them as calendar dates. The formula’s arguments specify ten rows, one column, a starting date, and a step of one. It needs clear cells below the formula so the results can spill.
Skip weekends and handle working days
A normal date series includes Saturdays and Sundays. If a work schedule should include weekdays only, drag the dates and choose Fill Weekdays from Auto Fill Options. You can also use a formula, which is useful when dates depend on an earlier date rather than a fixed starting selection.
With the first date in A2 and the next workday to be calculated in A3, enter =WORKDAY(A2,1). If A2 is Friday, January 9, 2026, the formula returns Monday, January 12, because it skips the weekend. Fill the formula down to continue the sequence. WORKDAY excludes Saturdays and Sundays by default; it does not automatically know which public holidays apply to a particular organization or country.
To exclude a holiday list as well, put holiday dates in H2:H10. With the prior workday in A2 and the next result in A3, use =WORKDAY(A2,1,$H$2:$H$10). The dollar signs keep the holiday range fixed when you fill the formula down. Enter the holidays as real Excel dates, not text, and leave unused cells outside the listed holiday range when possible. If your weekend days differ from Saturday and Sunday, Excel also has WORKDAY.INTL, which lets you specify a weekend pattern.
Make monthly and other calendar schedules
Monthly sequences are not always the same as adding a fixed number of days. For a schedule on the first day of each month, start with a date such as January 1 and use the Series dialog with Month as the date unit. An alternative formula is EDATE, which moves a date by a specified number of months.
With the starting date in A2 and the next monthly date in A3, enter =EDATE(A2,1). If A2 is January 1, 2026, the result is February 1, 2026; filling down produces March 1 and later month starts. Use 3 as the second argument for a quarterly sequence. EDATE is useful for monthly anniversaries too, but a date such as January 31 does not have an equivalent day in every month. Excel adjusts dates that fall beyond a month’s last day, so inspect month-end results before using them in a report or schedule.
For annual dates, a Series operation with the Year unit or a formula that advances the date by twelve months can work. Be cautious with February 29: not every year has that date, and the result will be adjusted in non-leap years. If a schedule must follow a specific business rule, document that rule and verify the generated dates rather than assuming every interval behaves like a fixed number of days.
Fix dates that repeat, display as numbers, or sort incorrectly
- The date repeats: The drag may have copied the cell instead of extending a series. Choose Fill Series in Auto Fill Options, or select two dates that show the desired interval before dragging.
- You see a number such as 46027: The value may be a valid date serial displayed with a General format. Select the cells and choose Home > Number Format, then select a date format.
- Excel will not recognize the entry as a date: The value may be text, perhaps because it includes an apostrophe or does not match the workbook’s regional date order. Try entering the date in a format Excel recognizes for your locale, or use DATE with separate year, month, and day values.
- Dates appear in an unexpected order: Check whether the workbook expects month/day/year or day/month/year. For example, 03/04/2026 can be ambiguous across regional settings. Use an unambiguous display format or create the date from separate components.
- Only some cells fill: Confirm that the selected range is large enough and that cells are not blocked by merged cells or other content. A dynamic-array formula also cannot spill into occupied cells.
Formatting changes how a date looks, not the date value itself. For example, a valid date can display as 5-Jan-2026, January 5, 2026, or a serial number depending on its number format. Sorting works reliably when the cells contain genuine date values; text that merely looks like a date may sort alphabetically instead of chronologically.
Which method should you use?
Use the fill handle for a quick run of consecutive dates. Use two starter dates when the gap is regular but not daily. Use Home > Fill > Series when you need a specific step, date unit, or stopping point. Use formulas when later dates should respond to edits in an earlier cell, and use SEQUENCE when you want a fixed-size spilled list in a version that supports it.
Keyboard filling can help once a formula is in place: select the formula cell and the cells below, then press Ctrl+D on Windows to fill down. On Mac, the equivalent is Command+D. This copies the formula pattern; it does not tell Excel to invent a date interval from a single date. For a one-time date entry rather than a sequence, enter the date directly—autofill is intended for extending values across cells, not for inserting today’s date into just one cell.
Frequently Asked Questions
How do I autofill dates in Excel without weekends?
Drag the date sequence, then choose Fill Weekdays from Auto Fill Options. For a formula-driven list, use WORKDAY with the previous date as its first argument and 1 as the number of working days.
How do I fill dates by month instead of by day?
Use Home > Fill > Series and choose Month as the Date unit, or provide two monthly starter dates before dragging. For a formula-based sequence, EDATE advances a date by a chosen number of months.
Why does Excel keep repeating the same date?
Excel may be copying the cell rather than extending the series. Select Fill Series in Auto Fill Options, or select two dates with the intended interval before dragging the fill handle.
Can Excel fill dates automatically when I add a new row?
A formula in the date column can calculate each row from the preceding date, but adding a row does not always populate a formula in every workbook layout. Excel Tables can carry formulas into new table rows when calculated columns are used; confirm the formula is present in the new row.
Can I generate a list of dates with one formula?
Yes. In Microsoft 365 or Excel 2021, SEQUENCE can return a spilled list when entered in an empty cell. Format the output as dates, and make sure the cells where the results should appear are clear.
Related
- Convert H:M:S to a Number in Excel
- Contact Number List Template for Excel: Setup Guide
- Contacts List Template Excel: Build a Useful Workbook
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Table Filter Multiple Columns: How It WorksYes. In an Excel table, you can filter multiple columns at the same time by choosing a filter…
- Excel Top N Formula: Find the Highest Values and RowsTo return the top N numbers in Excel for Microsoft 365, use =LARGE(B2:B20,SEQUENCE(3)) to spill the three largest…
- Excel Filter Duplicates Without Deleting Data SafelyYes. In Excel for Microsoft 365 on Windows, add a helper column that identifies repeated values, then choose…
- Excel MID Function From the Right: Formulas That WorkNo: Excel’s MID function always counts characters from left to right. To take a fixed number of characters…
- Date Filter Formula in Excel: Examples and TipsIn Excel for Microsoft 365, use the FILTER function to return rows whose dates meet your criteria. For…
- Filter Excel Table by Color: Steps and TroubleshootingYes. In Excel for Microsoft 365 on Windows, open the filter arrow in the table column containing the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.