4 days in a row then skip 3

[deemer98]

Good afternoon,

I want to create a running log of dates where there are 4 dates in a row (13 Feb 23 in cell A2, 14 Feb 23 in A3, 15 Feb 23 in A4, 16 Feb 23 in A5) then I want A6 to start at 20 Feb 23 (skip 3 days) and then as I drag down, it populates 4 days, then skips the next 3....over and over again. I hope that makes sense! Thanks!

 

[Joe4]

Here is one easy way:
1. Manually enter the dates in cells A2:A5
2. In cell A6, enter the following formula:

=A2+7

3. Copy the formula in cell A6 down column A as far as you need to go.

 

[awoohaw]

How about:
This is skipping 3 rows, so may not fit your need.

Mr Excel 8.xlsm
	A	B
1	Date
2	2023-02-13
3	2023-02-14
4	2023-02-15
5	2023-02-16
6
7
8
9	2023-02-20
10	2023-02-21
11	2023-02-22
12	2023-02-23
13
14
15
16	2023-02-27
Sheet13

Cell Formulas
Range	Formula
A2:A16	A2	=IF(MOD(ROW(A2)-2,7)+1<=4,DATE(2023,2,13)+(ROWS($A$2:A2)-1),"")

 

[deemer98]

Here is one easy way:
1. Manually enter the dates in cells A2:A5
2. In cell A6, enter the following formula:

=A2+7

3. Copy the formula in cell A6 down column A as far as you need to go.

Perfect and so simple! Thank you!

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[deemer98]

How about:
This is skipping 3 rows, so may not fit your need.

Mr Excel 8.xlsm
	A	B
1	Date
2	2023-02-13
3	2023-02-14
4	2023-02-15
5	2023-02-16
6
7
8
9	2023-02-20
10	2023-02-21
11	2023-02-22
12	2023-02-23
13
14
15
16	2023-02-27
Sheet13

Cell Formulas
Range	Formula
A2:A16	A2	=IF(MOD(ROW(A2)-2,7)+1<=4,DATE(2023,2,13)+(ROWS($A$2:A2)-1),"")

Impressive but not really what I needed. Thanks!