HOW TO Create a list of sequential dates

1 min


0

Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 

You can quickly create a list of dates, in sequential order, by using the Fill Handle  or the Fillcommand.

Use the Fill Handle

  1. Select the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential dates.
  2. 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

  1. Select the cell with the first date. Then select the range of cells you want to fill.
  2. Select Home > Editing > 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.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.


Like it? Share with your friends!

0
Sande Kennedy

Sande Kennedy is the founder of SandeKennedy.com & Kenyans247.com He is a Kenyan-based Internetprenuer,blogger Political Activist,informer who has an interest in politics, governance, corporate-fraud and human-interest. Kindly drop me a note if you feel aggrieved on any matter that you would want to be highlighted. Twitter @itssandekennedy , Instagram @itssandekennedy WhatsApp: +254791890826 Read More about me here

0 Comments

1
Would you like to get published on this Popular Blog? You can now email Sande Kennedy any breaking news, Exposes, story ideas, human interest articles or interesting videos on: info@sandekennedy.com. Videos and pictures can be sent to +254 791890826 here on WhatsApp by clicking this send button
Powered by