I want to create a sheet with 2 columns where it will auto populate rows with dates starting on the start date provided and end on the end date provided. Start Date would be provided in A2 and end date in B2. Also, it should be in sequence and 2 weeks apart (as in Pay weeks). I attached an image of end result. BTW, I did this manually.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Start and End Dates Provided
- Thread starter PG626
- Start date
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,966
- Office Version
- 365
- Platform
- Windows
- Mobile
Isn't that just add 14 to the dates (btw what error checking error are you getting in the cells?)?
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A3:B20 | A3 | =A2+14 |
Upvote
0
I see what you mean, however, if the start and end dates are provided, what is the formula where it will auto populate rows as shown without dragging or anything. For example, the start date will be input in A2 and end date in B2. What formula do I need so it gives me the rows with the dates separated by 2 weeks?
Upvote
0
Similar threads
- Solved
