enter sequential dates automatically

0

How can I enter sequential dates in a column automatically?

Answer
Discuss

Answers

0

Type the first date in the first cell and hit Enter; then, click that cell with the date and then move your mouse to the bottom-right of the cell, click it and drag the mouse down for as many cells as you want. This will auto-fill the date with an increment of one day for each cell.

Discuss
0

If you enter a date in cell A1, the formula =A1+1 will generate a date one day after the date in A1.

To write a date one month from the date in A1 you can use =EDATE(A1, 1)

The formula =DATE(YEAR(A1), MONTH(A1),1) will generate the date as on the first day of the month in A1.

The following formula will return the last day of the month in A1 (even if it is Feb 29)

EDATE(DATE(YEAR(A1), MONTH(A1),1), 1)-1

To do any or all of that "automatically" you would need VBA.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login