continous formulas if this date give me this but if this other date five me that and so on

	A	B	C
1	Date	Pay Pd
2	Sun 25 Dec 2016	1	B2: =INT((A2 - "12/11/16")/14)
3	Sat 07 Jan 2017	1
4	Sun 08 Jan 2017	2
5	Tue 21 Mar 2017	7
6	Tue 28 Mar 2017	7
7	Wed 29 Mar 2017	7
8	Sat 01 Apr 2017	7
9	Thu 22 Jun 2017	13
10	Sat 24 Jun 2017	13
11	Thu 29 Jun 2017	14
12	Fri 07 Jul 2017	14
13	Sun 16 Jul 2017	15
14	Wed 09 Aug 2017	17
15	Sat 12 Aug 2017	17
16	Fri 18 Aug 2017	17
17	Tue 05 Sep 2017	19
18	Mon 18 Sep 2017	20
19	Tue 03 Oct 2017	21
20	Sun 15 Oct 2017	22
21	Sat 21 Oct 2017	22
22	Fri 03 Nov 2017	23
23	Fri 08 Dec 2017	25
24	Tue 12 Dec 2017	26

Hi and welcome to the forum

I suspect there's a typo there and you meant Pay 3 is Jan 22 - Feb 4

In B1 assuming a date in A1

Formula:

Please Login or Register  to view this content.