Connect with us

Hi, what are you looking for?

Sande KennedySande Kennedy

Business

HOW TO Create a list of sequential dates

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.

Click to comment

You must be logged in to post a comment Login

Leave a Reply

You May Also Like

General News

Alleged NYS fraudster Senator Murkomen is burning the midnight oil to fool Kenyans that he is humble and in touch with hoi polloi even...

Uncategorized

There’s immorality everywhere you look in Kenya these days. Because of bribes paid out to Communication Authority of Kenya (CAK) board members and senior...

Uncategorized

Registered Voters RAILA FINAL TALLY UHURU FINAL TALLY Baringo County 232,258                       33,875                         160,782 Bomet County 322,012                       35,461                         225,900 Bungoma County...

Uncategorized

Yes, some of you may call it stupidity. Clearly, the society we are currently living in seems to be crossing the lines. From Son playing...

Copyright © 2022 SandeKennedy.