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.