Hi all,
I have this data: [eu format (dd/mm/yy)]
10/08/21 | 500 | 10/09/21 | 1500 | 11/10/21 | 2500 | 11/11/21 | 3000 | 11/12/21 | 2500 | 11/01/22 | 1500 | 11/02/22 | 1000 | 11/03/22 | 1500 | 11/03/22 | 1000 | 11/03/22 | 500 |
I need a formula that give me 7500 ossia sum all values that have expired as of today
Tia. Maurizio
I have this data: [eu format (dd/mm/yy)]
10/08/21 | 500 | 10/09/21 | 1500 | 11/10/21 | 2500 | 11/11/21 | 3000 | 11/12/21 | 2500 | 11/01/22 | 1500 | 11/02/22 | 1000 | 11/03/22 | 1500 | 11/03/22 | 1000 | 11/03/22 | 500 |
I need a formula that give me 7500 ossia sum all values that have expired as of today
Tia. Maurizio