Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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