Set Analysis Date Range In Qlik Sense Desktop

[BlakeGri2093]

Dear Qlik sense experts
I wanna count the number of contract on the next day and from day 2 to day 7,day 8 to day 30 and etc with the date start is today (4/6/2019).  Can someone help me with this? I sincerely appreciate your effort and kind assistance.

Contract No	Date
10719227	06/12/2017
10664916	02/12/2018
10270315	15/11/2018
9950188	01/05/2018
9983190	01/11/2018
10176700	08/11/2018
10777992	08/12/2018
10325880	18/11/2017
10842487	16/12/2018
10293569	17/11/2018
10439690	01/09/2018
10576281	01/12/2019
10435623	01/06/2017
10368401	01/12/2018
10136630	04/11/2018
11004747	19/06/2018
10941872	19/12/2018
10592878	13/12/2019
11127129	01/01/2019
10402093	18/04/2018
11024282	01/01/2019
11125790	01/04/2019
10413789	01/12/2018
10164752	01/12/2018
10200464	10/05/2018
10661803	01/03/2019
10675903	05/12/2018
10851409	14/02/2018
10201292	08/01/2018
10097252	01/11/2017
11099194	01/01/2020
10425944	01/12/2018
10824499	12/03/2019
10509570	01/07/2018
10838976	14/12/2018
9898805	01/11/2017
10977178	17/12/2018
10621777	01/12/2018
10101639	01/11/2018
11086296	01/01/2019
10874489	16/12/2017
10001031	01/11/2018
10163108	07/11/2018
10792087	09/12/2018
10297375	15/11/2018
11111404	01/04/2018
10666938	01/12/2018
10924015	19/12/2018
9957965	01/11/2017
11023269	20/12/2018
10564260	01/06/2019
9993780	01/05/2019
10972243	01/01/2019
9786435	01/11/2018
10641672	01/12/2018
10117404	02/11/2018
10839227	13/07/2018
11078525	01/01/2019
10864897	16/12/2018
10582973	05/12/2018
11110585	01/03/2018
10421887	18/11/2018
10460678	01/12/2019
10374619	17/11/2018
10006930	01/11/2018
10371970	16/05/2019
11094255	01/01/2019
10407035	01/12/2018
10002817	01/02/2018
10571936	01/12/2018
10368363	01/12/2019
10438282	19/11/2018
10154851	10/11/2017
10504067	01/12/2018

[Channa]

=Count({$<Date={"<=$(=Date(Today(),30))>=$(=date(Today(),0))"}>}ContractNo)

this will bring upcoming 30 days contracts

[BlakeGri2093]

@Channa : i try your expression but it doesn't work.

[Channa]

you source file date format has some problem 

find the attach

=Count({$<Date={"<=$(date(Date(Today(),30),'DD/MM/YYYY'))>=$(date(Date(Today(),0),'DD/MM/YYYY'))"}>} distinct Contract)

[Channa]

i change the source

please find the xls...ur source has showing nulls

[BlakeGri2093 · Accepted solution]

@Channa : already found the problem for my data set. The format of date field is 'M/D/YYYY' that why i need to use the function date with format reference. This is my expression: count({<Date={"$(=date(today(),'M/D/YYYY'))<=$(=date(today()+30,'M/D/YYYY'))"}>} contract No). Thank you for your suggestion and have a nice day.