Calculate Weeks Apart

[mowermutt]

Hello,

I am having difficulty since I have never used Excel to understand a great deal of what I am reading. I need to count out weeks, 4, 6, 8 depending on what client I am working with from July 15 - December 24 2019. I cannot figure out how to use the excel sheet to make that happen. Can anyone give me a hand with the directions please?

Thanks

 

[Dave Patton]

If you need every second Monday, see the example below.

Based on client etc., please give more information and examples.

Excel 2010
	A	B
2	Mon Jul 15, 2019
3	Mon Jul 29, 2019	2nd
4	Mon Aug 12, 2019	4th
5	Mon Aug 26, 2019
6	Mon Sep 09, 2019
1b

Cell Formulas
Range	Formula
A3	=A2+14
A4	=A3+14
A5	=A4+14
A6	=A5+14

 

[mowermutt]

Those are the things that I am finding that I do not understand. The 2 tables you included are Greek to me, is there an idiot explanation perhaps?

Client 1. Every six weeks from July 15 through December. I have 280 clients all requiring different weeks apart on different starting dates

 

[Dave Patton]

Copy the formulas to the right as required.

Excel 2010
	B	C	D	E	F
1		Interval wks	Start
2	Client 1	2	15-Jul-19	29-Jul-19	12-Aug-19
3	Client 2	3	20-Jul-19	10-Aug-19	31-Aug-19
4	Client 3	4	22-Jul-19	19-Aug-19	16-Sep-19
1bb

Cell Formulas
Range	Formula
E2	=D2+$C$2*7
E3	=D3+$C$3*7
E4	=D4+$C$4*7
F2	=E2+$C$2*7
F3	=E3+$C$3*7
F4	=E4+$C$4*7

 

[mowermutt]

I'll try and give it a shot. Thanks for the help.