Formula for every Tuesday of the year

[new2excel__12]

Hi everyone!
In the top row of my document, I need to write a date of every Tuesday for the rest of the year. It takes a while to manually type them all, is there a faster way? I have attached a screenshot. Thanks to anyone who will take the time to respond to this!

 

[Joe4]

Just enter your first one in, and then write a formula to add 7 and copy across.
So, if your first date in in cell G1, enter this formula in H1:

=G1+7

and copy across for as far as you need to go.

 

[Fluff]

Slightly longer than Joe's idea, but this will spill across as far as needed.

Fluff.xlsm
	G	H	I	J	K	L	M	N	O	P	Q
1	23/08/2022	30/08/2022	06/09/2022	13/09/2022	20/09/2022	27/09/2022	04/10/2022	11/10/2022	18/10/2022	25/10/2022	01/11/2022
Report

Cell Formulas
Range	Formula
H1:Z1	H1	=WORKDAY.INTL(G1,SEQUENCE(,NETWORKDAYS.INTL(G1,DATE(YEAR(G1),12,31),"1011111")),"1011111")
Dynamic array formulas.

 

[new2excel__12]

Just enter your first one in, and then write a formula to add 7 and copy across.
So, if your first date in in cell G1, enter this formula in H1:

=G1+7

and copy across for as far as you need to go.

I really appreciate the quick response! Thank you so much!!!

 

[new2excel__12]

Slightly longer than Joe's idea, but this will spill across as far as needed.

Fluff.xlsm
	G	H	I	J	K	L	M	N	O	P	Q
1	23/08/2022	30/08/2022	06/09/2022	13/09/2022	20/09/2022	27/09/2022	04/10/2022	11/10/2022	18/10/2022	25/10/2022	01/11/2022
Report

Cell Formulas
Range	Formula
H1:Z1	H1	=WORKDAY.INTL(G1,SEQUENCE(,NETWORKDAYS.INTL(G1,DATE(YEAR(G1),12,31),"1011111")),"1011111")
Dynamic array formulas.

I really appreciate the quick response! Thank you so much!!!

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[Biz]

Slightly longer than Joe's idea, but this will spill across as far as needed.

Fluff.xlsm
	G	H	I	J	K	L	M	N	O	P	Q
1	23/08/2022	30/08/2022	06/09/2022	13/09/2022	20/09/2022	27/09/2022	04/10/2022	11/10/2022	18/10/2022	25/10/2022	01/11/2022
Report

Cell Formulas
Range	Formula
H1:Z1	H1	=WORKDAY.INTL(G1,SEQUENCE(,NETWORKDAYS.INTL(G1,DATE(YEAR(G1),12,31),"1011111")),"1011111")
Dynamic array formulas.

Very nice formula with Sequence and utilising Weekend Number with 1 and 0.

 

[Fluff]

Thanks