Count within Date interval

[juraj_pavol]

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.