Hi guys, how are you? Guys I don't know which one logic I need here to place dates by counties by months.
I need place only earlier date in my Month cell.
Example If I have date: 01.01.2020 , 05.01.2020 , 07.01.2020 then I need only earlier date from January = 01.01.2020 in cell Date 2020
I search on youtube.com and they use count products. or If count max or min.
My problem is I should search date through Country 1 Country 2 Country 3 and Country 4 and take only earlier date from January, February and etc.
I need place only earlier date in my Month cell.
Example If I have date: 01.01.2020 , 05.01.2020 , 07.01.2020 then I need only earlier date from January = 01.01.2020 in cell Date 2020
I search on youtube.com and they use count products. or If count max or min.
My problem is I should search date through Country 1 Country 2 Country 3 and Country 4 and take only earlier date from January, February and etc.
country.xlsm | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Country1 | Country2 | Country3 | Country4 | Date1 | No | city | Months | Date 2020 | Date 2021 | ||||
2 | America | Canada | Canada | America | 01.01.2021 | 1 | America | January | only first date from january | only first date from january | ||||
3 | Canada | America | America | Canada | 05.01.2021 | February | ||||||||
4 | America | Canada | America | America | 02.03.2020 | March | ||||||||
5 | Canada | America | America | America | 21.06.2021 | April | ||||||||
6 | America | America | America | America | 20.07.2021 | May | ||||||||
7 | Canada | Canada | Canada | America | 06.08.2021 | June | ||||||||
8 | America | America | America | America | 13.02.2021 | July | ||||||||
9 | Canada | Canada | America | Canada | 02.04.2020 | August | ||||||||
10 | America | America | Canada | Canada | 03.04.2021 | September | ||||||||
11 | America | America | America | America | 01.01.2020 | October | ||||||||
12 | America | America | America | America | 15.10.2021 | November | ||||||||
13 | Canada | Canada | America | America | 16.11.2021 | December | ||||||||
14 | 2 | Canada | January | |||||||||||
15 | February | |||||||||||||
16 | March | |||||||||||||
17 | April | |||||||||||||
18 | May | |||||||||||||
19 | June | |||||||||||||
20 | July | |||||||||||||
21 | August | |||||||||||||
22 | September | |||||||||||||
23 | October | |||||||||||||
24 | November | |||||||||||||
25 | December | |||||||||||||
WELDERS INFO |