Hello everyone,
I am trying to assign a value to each date of the calendar days. If the calendar day is less or equal than the date from the table than it will have that value assigned, otherwise the next value. I copy here and example of the excel. How could I solve it? Thank you very much!!!
<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>
I am trying to assign a value to each date of the calendar days. If the calendar day is less or equal than the date from the table than it will have that value assigned, otherwise the next value. I copy here and example of the excel. How could I solve it? Thank you very much!!!
Date | Value | 20/06/2018 | 1 | |
20/06/2018 | 1 | 21/06/2018 | 2 | |
21/06/2018 | 2 | 22/06/2018 | 2 | |
26/06/2018 | 5 | 23/06/2018 | 2 | |
29/06/2018 | 4 | 24/06/2018 | 2 | |
01/07/2018 | 6 | 25/06/2018 | 2 | |
09/07/2018 | 4 | 26/06/2018 | 5 | |
13/07/2018 | 3 | 27/06/2018 | 5 | |
28/06/2018 | 5 | |||
29/06/2018 | 4 | |||
30/06/2018 | 4 | |||
01/07/2018 | 6 | |||
02/07/2018 | 6 | |||
03/07/2018 | 6 | |||
04/07/2018 | 6 | |||
05/07/2018 | 6 | |||
06/07/2018 | 6 | |||
07/07/2018 | 6 | |||
08/07/2018 | 6 | |||
09/07/2018 | 4 |
<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>