Hi all,
I try to solve following problem but with no success.
I have data in following structure
| Item name | Activation date | Expiration date |
|---|
| Blue | 01/2018 | 03/2018 |
| Gree | 01/2018 | 05/2018 |
| Red | 02/2018 | 05/2018 |
| Pink | 03/2018 | 06/2018 |
| Black | 04/2018 | 06/2018 |
On the sheet I have Data picker where I can select date in format eg. 04/2018 = Select month
1. I need count all records where Activation date <=Select month <= Expiration date
I try this but it not works:
Count(distinct{$<[Select month]={">=[Activation date]<=[Expiration date]"}>}[Item name])
2. I need count all records where Activation date <=Select month <= Expiration date
and also if Expiration date is NULL it will be counted to total count
Please could you help me.
Thanks in advance.
