Excel Formula for Every other Every third weekend

[Silvermoon324]

Hi All,
I was wondering if anyone has a formula to calculate the dates for a every other every weekend schedule for the year 2018, 2019.
As an example - the month of January, the working weekends would be January 6,7 and January 20,21 then off for 2 weekends and back on for Feb 10,11 and 24,25. I can manually calculate the dates out, but thought I'd give this a chance. Any help is greatly appreciated, thanks!

 

[VBA Geek]

you could have the date of the first Saturday on A1 and then A2

=A1+((MOD(ROWS(A$2:A2)-1,2)+2)*7)

then column B would just be A2+1

Excel 2013/2016
	A	B
1	Saturday, January 06, 2018
2	Saturday, January 20, 2018	Sunday, January 21, 2018
3	Saturday, February 10, 2018	Sunday, February 11, 2018
4	Saturday, February 24, 2018	Sunday, February 25, 2018
5	Saturday, March 17, 2018	Sunday, March 18, 2018
6	Saturday, March 31, 2018	Sunday, April 01, 2018
7	Saturday, April 21, 2018	Sunday, April 22, 2018
8	Saturday, May 05, 2018	Sunday, May 06, 2018
9	Saturday, May 26, 2018	Sunday, May 27, 2018
10	Saturday, June 09, 2018	Sunday, June 10, 2018
11	Saturday, June 30, 2018	Sunday, July 01, 2018
12	Saturday, July 14, 2018	Sunday, July 15, 2018
13	Saturday, August 04, 2018	Sunday, August 05, 2018
14	Saturday, August 18, 2018	Sunday, August 19, 2018
Sheet4