Hello everyone!
I’m trying to resolve this issue more than week but unfortunately I couldn’t without help!
I will try my best to explain exactly what I want and for your convenience I’ve made a table with examples.
[/tr]
In column “A” I have list of dates and in row 1 I have list of months and years. I want to separate dates in column “A” and put it in respective month and year from row 1. For example in column “B” I want excel to show me only dates from June 2018; in column “C” only dates from July 2018 and etc. Finally I want this dynamically – when I write a new date in column “A” excel automatically to put it in respective cell under respective month and year.
I’m trying to resolve this issue more than week but unfortunately I couldn’t without help!
I will try my best to explain exactly what I want and for your convenience I’ve made a table with examples.
A | B | C | D | E | |
1 | Dates | Jun-18 | Jul-18 | Aug-18 | Sep-18 |
2 | 14/06/2018 | 14/06/2018 | 10/07/2018 | 08/08/2018 | |
3 | 14/06/2018 | 14/06/2018 | 12/07/2018 | 14/08/2018 | |
4 | 23/06/2018 | 23/06/2018 | 25/07/2018 | 23/08/2018 | |
5 | 10/07/2018 | 25/07/2018 | 23/08/2018 | ||
6 | 12/07/2018 | 30/08/2018 | |||
7 | 25/07/2018 | ||||
8 | 25/07/2018 | ||||
9 | 08/08/2018 | ||||
10 | 14/08/2018 | ||||
11 | 23/08/2018 | ||||
12 | 23/08/2018 | ||||
13 | 30/08/2018 |
[/tr]
In column “A” I have list of dates and in row 1 I have list of months and years. I want to separate dates in column “A” and put it in respective month and year from row 1. For example in column “B” I want excel to show me only dates from June 2018; in column “C” only dates from July 2018 and etc. Finally I want this dynamically – when I write a new date in column “A” excel automatically to put it in respective cell under respective month and year.