To create dates that increase in order, enter the first two dates in adjacent cells, select both, and drag the fill handle across the cells you want to fill. Excel detects the interval and continues the sequence. Regular copy and paste usually duplicates dates, so use the fill handle or Fill Series when you want later dates rather than identical copies.
What You’ll Need
- A Microsoft Excel workbook in Excel for Microsoft 365 on Windows. The same basic fill-handle method is available in Excel for Mac and Excel for the web, although ribbon layouts can vary slightly.
- A starting date that Excel recognizes as a date, plus a decision about the interval: calendar days, weekdays, weeks, months, or years.
- A blank destination range, or an existing sequence you can extend. If you are copying dates to another place, decide whether the destination range should be the same size as the copied range.
Step-by-Step
- Choose the sequence and its first dates. Decide what each step should mean before filling cells. For consecutive calendar days, use dates one day apart. For a weekly series, use dates seven days apart. For monthly dates, use the same day of the month where possible. For example, a sequence starting November 3, 2026 might begin with November 3 and November 4. Excel will use the gap between those entries to work out what comes next. The date’s appearance depends on your regional settings, so enter it in a format Excel accepts on your computer.
- Enter the first date in a cell. Click the starting cell, such as A2, type the date, and press Enter. Check that Excel recognizes it: dates are usually aligned to the right by default, and changing the cell’s number format to a date format should change how it displays. If the entry stays as text, Excel may not be able to continue it as a date series. Correct the entry before filling.
- Enter the next date to establish the interval. In the cell directly below the first date, enter the next date. For a daily sequence, make it one calendar day later; for weekly dates, make it seven days later. Select both starting cells, for example A2:A3. Starting with two cells is the most dependable approach because Excel can infer the intended interval instead of simply repeating one value.
- Drag the fill handle to extend the sequence. With both starter cells selected, point to the small square at the bottom-right corner of the selection. When the pointer becomes a small black plus sign, drag down to the last row you want to fill. For a horizontal sequence, drag right instead. Release the mouse button and check the final dates. If you drag too far, use Undo or clear only the extra cells.
- Choose a fill option if Excel repeats rather than increments. After a fill, Excel may show an Auto Fill Options button beside the filled area. Open it and choose Fill Series if that option is available. Choose Copy Cells only when you want the original values repeated. The exact options can depend on the selected cells and Excel version. If no options button appears, undo the fill and drag again with both starter dates selected.
- Use Fill Series for a controlled sequence. Enter one starting date and select the full range you want to populate, including the starting cell. On Windows, go to Home > Fill > Series. In the Series dialog, choose Columns for a vertical range or Rows for a horizontal one. Select Date, choose a date unit such as Day or Weekday, and enter a step value. A step value of 1 with Day makes consecutive calendar dates; a step value of 1 with Weekday skips Saturdays and Sundays. Select OK and review the result. The dialog’s availability and placement can differ in Excel for Mac or the web; use the fill handle there if you do not see this command.
- Copy a completed sequence to another location. Select the cells containing the sequence and press Ctrl+C on Windows. Click the first destination cell and press Ctrl+V. This copies the dates and, depending on the selection, their formatting. For a predictable result, make the destination the same size as the copied range. If you want to continue the sequence into additional blank cells, copy or enter the first two dates there and use the fill handle to extend them rather than expecting a normal paste to create new dates.
- Check and format the results. Look over the start, middle, and end of the filled range to confirm the interval is right. If dates appear as serial numbers or in an unwanted style, select the cells and use Home > Number Format to choose a date format. Formatting changes how a date looks, not the underlying sequence. In Excel for Mac, Command+C and Command+V replace Ctrl+C and Ctrl+V; dragging the fill handle works similarly. Excel for the web also supports filling with the handle, though the ribbon and available dialog commands may differ.
Alternative for a simple daily series: If A2 contains the first date and you want the next date in A3, enter =A2+1 in A3. This adds one day to the date in A2; for example, if A2 is November 3, 2026, A3 returns November 4, 2026. Fill the formula down to continue the sequence. This keeps later cells linked to the prior date, whereas the fill-handle method creates date entries directly.
Common Mistakes
- Using Ctrl+V and expecting dates to advance. Copying a single date and pasting it generally makes another copy of that same date. Paste is useful for moving or duplicating an existing sequence, but use Fill Series or the fill handle to generate new dates.
- Selecting only one starting date. If you drag a single cell, Excel may copy it or infer a sequence depending on the value and fill action. Two consecutive starter dates make the intended interval clear and reduce surprises.
- Entering dates as text. An apostrophe at the start, a leading space, or a date format Excel does not recognize can leave the entry as text. Re-enter it in a format accepted by your regional settings, and verify that Excel treats it as a date before filling.
- Confusing calendar days with weekdays. A daily series includes weekends. If you need Monday-to-Friday dates, use the Weekday date unit in the Series dialog where available, or create a weekday series using the relevant fill options. Check around holidays too: skipping weekends does not automatically skip public holidays.
- Assuming every month has the same number of days. Monthly sequences can behave differently around the end of a month because months have different lengths. Inspect dates around February and 30- or 31-day months, and use a purpose-built approach if every result must be the last day of its month.
- Filling into cells that already contain data. A drag or Series operation can overwrite existing entries. Check the destination range first, and keep a copy of important data before filling over it.
Tips
- Make the interval explicit. Two starter dates can define more than a one-day step. For example, November 3 and November 10 set a weekly interval; filling the series continues in seven-day jumps.
- Use the right direction. Put the seed dates in a column and drag down for a vertical list, or put them in a row and drag right for a horizontal timeline. The same interval logic applies in either direction.
- Use weekday filling for work schedules. In the Series dialog, choose Date and Weekday when you want to skip weekends. If the command is unavailable in your Excel interface, create the dates with the fill handle and review weekends, or use a formula-based workday approach if holidays also need to be excluded.
- Separate values from appearance. A date can display as 3-Nov-2026, 11/3/2026, or another format while representing the same underlying date. Apply a consistent date format after filling rather than typing dates as text just to control how they look.
- Use Undo for a quick correction. If the fill repeats values or uses the wrong interval, press Ctrl+Z on Windows or Command+Z on Mac immediately, then reset the starter cells and try again. Avoid continuing to edit if you need to undo the fill, because Undo reverses recent actions in order.
- Copy a sequence when you need the same dates elsewhere. After creating and checking a series, copy the whole range to another area when you want an identical set of dates. If the destination must be longer, extend it with the fill handle rather than pasting a short list and assuming Excel will invent the remaining dates.
Troubleshooting
The dates repeat instead of increasing: Undo the fill, enter a second date that shows the desired gap, select both seed cells, and drag the fill handle from the edge of the selection. If you used a menu command, confirm the Series type is Date and the step value is appropriate. A step value of 1 means one unit of the selected date unit, not necessarily one calendar day.
The cells show numbers such as 46329: Excel stores dates as serial numbers, so the values may be valid even when the display looks wrong. Select the range and apply a date format from Home > Number Format. If changing the format does not produce dates, the entries may be text rather than real date values.
The fill handle is missing or will not drag: Confirm that the range is selected and look for the small square at its lower-right corner. If it is not available, Excel’s fill-handle setting may be disabled. On Windows, check File > Options > Advanced for the editing option that enables the fill handle and cell drag-and-drop. The setting location differs on Mac. You can use Home > Fill > Series on Windows instead when available.
The result is off by one day or starts on the wrong day: Check the first two entries and the system’s date interpretation. A date such as 4/5/2026 can mean different things under different regional settings. Use an unambiguous date entry accepted by your Excel setup, then verify the displayed date before filling. Also confirm whether you wanted calendar days or weekdays.
The sequence skips or changes unexpectedly at month-end: Review the starter dates and the selected date unit. A monthly interval is not the same as a fixed number of days, and a date near the end of a month may not have an identical day number in the next month. If the rule is specifically “last day of each month,” choose a method designed for month-end dates and check its results rather than relying on a simple drag.
Frequently Asked Questions
Why does copy and paste give me the same date?
Copy and paste duplicates the selected cell’s value. To create later dates, select two dates that establish the interval and drag the fill handle, or use Home > Fill > Series on Windows.
Can I fill dates without weekends?
Yes. In the Windows Series dialog, choose Date and set Date unit to Weekday. This skips Saturdays and Sundays, but it does not remove public holidays automatically.
How do I make dates increase by a week?
Enter two dates seven days apart, select both, and drag the fill handle. Alternatively, use Fill Series with Date, a Day unit, and a step value of 7.
Can I create a sequence across columns instead of down rows?
Yes. Enter the starter dates in adjacent cells across a row, select them, and drag the fill handle to the right. In the Series dialog, choose Rows.
Will the same steps work in Excel for Mac or Excel for the web?
The fill-handle method works in both. On Mac, use Command+C, Command+V, and Command+Z for the common copy, paste, and undo shortcuts. Excel for the web has a different interface and may not show the same Series dialog options as desktop Excel.
Related
- Enable Editing in Excel: Exit Protected View
- How to Close an Excel Sheet With the Keyboard Quickly
- How to Close an Open Dialog Box in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Insert Row and Copy Formulas From Above EasilyTo insert a row and copy formulas from above in Excel for Microsoft 365 on Windows, right-click the…
- Filter Cells With Specific Text in Excel: A Quick GuideTo filter cells by text in Excel for Microsoft 365 on Windows, select your data, choose Data >…
- Excel VLOOKUP With Two Criteria: Formula and ExamplesYes. To use VLOOKUP with two criteria, combine the criteria into one helper key, then look up that…
- Excel Formula for Tomorrow’s Date: TODAY()+1 ExplainedIn Excel, use =TODAY()+1 to return tomorrow’s date. Enter it in a cell and format that cell as…
- Excel Date Filter Multiple Criteria: Practical MethodsTo filter dates in Excel by multiple criteria, turn on AutoFilter, open the date column’s dropdown, and choose…
- Date Difference in Minutes in Excel: Formulas That WorkIf A2 contains a start date and time and B2 contains an end date and time, enter =(B2-A2)*1440…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.