Hi,
Can any one help how to covert the date string to date and sum the value based on below condition.
I have data set with Date as below in excel and i need to consider data for next six month i.e., for current month it should pick values from 07.2018 to 12.2018 and in next month it should pick values from 08.2018 to 01.2019
Input
Name | Date | Value |
A | 07.2018 | 100 |
A | 08.2018 | 200 |
A | 09.2018 | 300 |
A | 10.2018 | 400 |
A | 01.2019 | 500 |
B | 08.2018 | 600 |
B | 09.2018 | 700 |
B | 10.2018 | 800 |
C | 08.2018 | 900 |
C | 09.2018 | 1000 |
C | 02.2019 | 1100 |
Out Put
Name | Value |
A | 1000 |
B | 1300 |
C | 1900 |
Solved! Go to Solution.
Thank You i am able to fix it
No problem @Shank I'm glad we could get you to a solution! The way you structured your question and including sample data made it very easy to understand the problem!
Ben