Creating date cycles

[IamRade]

Good Day, please help with creating date cycles the first table has the cycle im looking for i know its suppose to loo at date between two date,

sample.xlsx
	A	B	C	D	E	F	G	H
1	Start	End	Cycle
2	2021/01/16	2021/02/15	Jan - feb 2021
3	2021/02/16	2021/03/15	Feb - Mar 2021
4	2021/03/16	2021/04/15	Mar - Apr 2021
5	2021/04/16	2021/05/15	Apr - May 2021
6	2021/05/16	2021/06/15	May - Jun 2021
7	2021/06/16	2021/07/15	Jun - July 2021
8
9
10
11
12	Ref	Name	Payment Date	Rec no	Method	Amount
13	1259820	BONGIWE GOJE	2021-01-25	12076	EFT Payment	-219,00
14	1429009	Zandile Sithole	2021-01-29	12126	Cash Payment	-876,00
15	1259679	Rachel Mokoatsi	2022-01-03	14964	Cash Payment	-220,00
16
17
18	Ref	Name	Payment Date	Rec no	Method	Amount	Cycle
19	1259820	BONGIWE GOJE	2021-01-25	12076	EFT Payment	-219,00	Jan - feb 2021
20
21
Sheet1

Cell Formulas
Range	Formula
B2,B4,B6	B2	=A2+30
A3:A7	A3	=B2+1
B3	B3	=A3+27
B5,B7	B5	=A5+29

 

[James006]

Hi,

In cell G19, you can test : =INDEX($C$1:$C$7,MATCH(C19,$A$1:$A$7,1))