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 |
Last edited by a moderator: