Microsoft Office Forums - View Single Post - [Solved] how to fill a series of dates

Thread: [Solved] how to fill a series of dates

View Single Post

Old

03-30-2016, 10:19 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

Select the cell with your start date.
Click Fill (on the Ribbon, Editing group) and click Series.
Select Columns.
Choose Date Unit, Step Value and type your last date
Click OK.

Last edited by xor; 03-31-2016 at 09:58 PM.

Reply With Quote