Auto Increment Date in Microsoft Excel 2013

How to auto Increment date in MS Excel 2013?


Increment Date is used to get the successive sequence of date. To increment date do the following
Step 1: Enter the date in a cell.
Step 2: In the successive cell, type "=" and press the up arrow key. You will get the cell reference of the preceding cell.
Step 3: Enter plus(+) and give the value to increment (Based in this value the dates will be incremented in the successive cells) and hit enter.
Step 4: Now click on the cell where the date is incremented and drag the mouse pointer to the extension you want to increment the date.

Related Topics