![]() Then drag the autofill handle to the range you have formatted in above steps and fill the date series. Then in the first cell of your selected range, type the start date you need. ![]() In the Format Cells dialog, click Number tab, and click Date from Category list, then select the date type you need from the Type list. To fill date series, firstly you need to select a range you want to fill the date series, and then right click to select Format Cells. ![]() But do you know we also can fill dates or only weekdays, months or years with Auto Fill function? This tutorial will tell you the way to auto fill dates or only weekdays/months/years in Excel.Īuto fill date series or weekdays/months/years in Excelġ. In Excel, the AutoFill function is widely used by us. ![]() How to auto fill date or only weekdays sequence in Excel? ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |