You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.
Use the Fill Handle
Select the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential dates.
Select the fill handle at the lower-right corner of the cell, hold down, and drag to fill the rest of the series. Fill handles can be dragged up, down, or across a spreadsheet.
Use the Fill command
Select the cell with the first date. Then select the range of cells you want to fill.
Select Fill > Series > Date unit. Select the unit you want to use.
Tip:You can sort dates much like any other data. By default, dates are sorted from the earliest date to the latest date.
Tip: For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4. Select the cells that contain the starting values. Drag the fill handle across the range that you want to fill.
Highlight the cells. You'll see a small blue box in the lower right corner. Drag the blue box any number of cells down or across. If the cells form a series of dates or numbers, the series will continue across the selected cells.
You can use the SEQUENCE function to auto-populate dates without having to click and drag your mouse. The structure for this is =SEQUENCE(rows, [columns], [start], [step]). This function allows you to specify the number of rows and columns for your dates, the start date and the numbered steps for the series.
Insert a helper column next to your date column to accommodate the sorting process. In the first cell of the helper column (C2), enter the formula “=SORT(B2:B,MONTH(B2:B),TRUE).” This formula sorts the dates in column B by month, from oldest to newest.
Re: Dates in my excel not filling sequentially only copying
Click and drag the fill handle (the small square in the bottom-right corner of the selected cell) to the desired range where you want to fill the dates. When you release the mouse button, a small options box should appear next to the filled cells.
On your Android phone or tablet, open a spreadsheet in the Google Sheets app. In a column or row, enter text, numbers, or dates in at least two cells next to each other. To highlight your cells, drag the corner over the cells you've filled in and the cells you want to autofill. Autofill.
Address: 569 Waelchi Ports, South Blainebury, LA 11589
Phone: +9958996486049
Job: Sales Manager
Hobby: Web surfing, Scuba diving, Mountaineering, Writing, Sailing, Dance, Blacksmithing
Introduction: My name is Prof. Nancy Dach, I am a lively, joyous, courageous, lovely, tender, charming, open person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.
