Macro that filter whole list by date

[Kartiksvn]

Mumbai Sale.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1										Mumbai Sale
2
3		Total Carats		Avg.				Total	Main	Round	Bro	Confirm	Balance
4		13,387.04		18,274.69				24,46,44,061	2,44,601	43,065	0	0	43,065
5	Search
6	ક્રમ	Carats	Details	Rate	%	Ext %	Bro %	Total	Main	Round	Bro (rs.)	Buyers	Broker	date	days	due date	days remain	bro	Over Days	Status
7	1	102.94	-2 Collection	17250	-4.00			17,04,686	1705	-314		S. Vinod	Manish	27-04-2021	10	07-05-2021	-101 Days	yes	101 Days
8	2	88.98	-2 Jew	23500				20,91,030	2091	30		Lallu Khopala	K. Goti	28-04-2021	150	25-09-2021	40 Days	yes	-40 Days
9	3	23.88	-2 Natts	12851	-4.00			2,94,607	294	607		Chirag gol	Ajay	28-04-2021	30	28-05-2021	-80 Days	yes	80 Days
10	4	98.40	+2 AAC	24201	-3.00			23,09,937	2309	937		Alfa (Mahek)	Pravin	22-04-2021	105	05-08-2021	-11 Days	yes	11 Days
11	5	54.70	+2 Natts	11350	-4.00			5,96,011	596	11		Dipak Manish	Ajay	27-04-2021	30	27-05-2021	-81 Days	yes	81 Days
12	6	168.11	+2 VVS	32000				53,79,520	5379	520		J K bhansali	Chirag Pipali	27-04-2021	90	26-07-2021	-21 Days	yes	21 Days
13	7	21.01	+2 LC	16151				3,39,333	339	333		Naresh decent	Raju goli	30-04-2021	120	28-08-2021	12 Days	yes	-12 Days
14	8	18.36	+2 AE Dagina	27000				4,95,720	495	720		Nice Diamond	Raju goli	24-04-2021	120	22-08-2021	6 Days	yes	-6 Days
15	9	16.54	-2 LC	41500	-3.00			6,65,818	665	818		Hirachand	Pradip	07-04-2021	10	17-04-2021	-121 Days	yes	121 Days
16	10	16.66	LB	14555	-10.00			2,18,238	218	238		Bajrang Diamond	Sharad	11-05-2021	5	16-05-2021	-92 Days	no	92 Days
17	11	49.46	-2 JEW	23500				11,62,310	1162	310		Lavaji Khopala	K. goti	14-05-2021	150	11-10-2021	56 Days	yes	-56 Days
18	12	43.71	-2 AE Dagina	33000				14,42,430	1442	430		JK Bhansali	Chirag Pipali	17-05-2021	85	10-08-2021	-6 Days	yes	6 Days
19	13	50.73	+2 AAA	27000				13,69,710	1669	-90		Nice Diamond	Raju goli	18-05-2021	120	15-09-2021	30 Days	yes	-30 Days
20		7.52	-2 Dagina	32000				2,40,640						18-05-2021	120	15-09-2021	30 Days	yes	-30 Days
21		1.83	-2 AE Jew	32000				58,560						18-05-2021	120	15-09-2021	30 Days	yes	-30 Days
22	14	55.80	+2 IF	38000	-3.00			20,56,788	2056	788		Hirachand	Pradip	19-05-2021	5	24-05-2021	-84 Days	yes	84 Days
Sale List

Cell Formulas
Range	Formula
B4,H4	B4	=SUM(B7:B600)
D4	D4	=H4/B4
I4	I4	=SUMIF($T$7:$T$600,"",$I$7:$I$600)
J4	J4	=SUM($J$7:$J$600)
K4	K4	=SUM($K$7:$K$600)
L4	L4	=SUMIF($T$7:$T$600,"<>",$I$7:$I$600)
M4	M4	=SUM((L4*1000)+J4-K4)
P7:P22	P7	=IF(O7="","",SUM(N7+O7))
Q7:Q22	Q7	=IF(O7="","",SUM(P7-TODAY()))
H7:H22	H7	=IF(B7="","",SUM(AB7)-(AB7)*(-G7/100))
S7:S22	S7	=IF(O7="","",SUM(TODAY()-P7))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A7:P600,R7:S600	Expression	=$T7="OK"	text	YES
B7:B600,I7:M600,P7:P600	Expression	=$S7=""	text	YES
B7:B600,I7:M600,P7:P600	Expression	=$S7>=0	text	NO
S7:S600	Other Type	Color scale		NO
S7:S600	Cell Value	<0	text	NO
Q7:Q600	Cell Value	<=0	text	NO
A7:G600,T7:U600,I7:O93,K94:O94,I95:O600,R7:R600	Expression	=OR(CELL("row")=ROW())	text	NO

I want macro that filter date wise P column with heading 'due date'. Thank you in advance.

 

[Kartiksvn]

this is the screenshot of my worksheet. I am already using macros like clear all filter, over due list which is filter with orange cells. And I need help for date filter macro which is not harm full sheet sequence.