Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Two more ways:

Have your first two dates in the first two cells. Select them both. Then left click on the little black square in the bottom right of the bottom cell. Drag it down as necessary. It will increment based on the difference between the two cells.

Cell A1 is your date. in cell A2, use the formula:


Then copy/drag it down as required.