Results to show in columns F,G and H. Please if possible don't use VB scripts
I would like excel to look at the days number in column A (7/6/2018 = 6), then go back that many days (including the day). For example: In Column A, If today is the 6th, then go back 6th,5th,4th,3rd,2nd, to the 1st.
If that is possible, then I also need it to combine cell values in C,D,E (in the same row) as C&D, C&E, D&E
<tbody>
</tbody>
So, the formula results in columns F,G and H would be F = 64 G = 62 H = 42
Albeit strange, I hope this is sensible to excel
Thank you
I would like excel to look at the days number in column A (7/6/2018 = 6), then go back that many days (including the day). For example: In Column A, If today is the 6th, then go back 6th,5th,4th,3rd,2nd, to the 1st.
If that is possible, then I also need it to combine cell values in C,D,E (in the same row) as C&D, C&E, D&E
A | B | C | D | E | F | G | H |
7/6/2018 | 3 | 8 | 4 | ||||
7/5/2018 | 1 | 9 | 4 | ||||
7/4/2018 | 4 | 5 | 1 | ||||
7/3/2018 | 1 | 6 | 7 | ||||
7/2/2018 | 5 | 3 | 3 | ||||
7/1/2018 | 6 | 4 | 2 | 64 | 62 | 42 | |
6/30/2018 | 5 | 2 | 9 |
<tbody>
</tbody>
So, the formula results in columns F,G and H would be F = 64 G = 62 H = 42
Albeit strange, I hope this is sensible to excel
Thank you