Filter Function with three criteria based on "AND"

[Toncar58]

Good day
I’m looking for help with the FILTER function. The aim is to filter data into a separate worksheet based on three criteria 1) All blank cells in a column, 2) Dates more than or equal to a certain date (based on a captured date in another cell), and 3) Dates less than or equal to a certain date (based on a captured date in another cell).
The formula I am using
=FILTER('CapLeg Fee Tracker'!$B$5:$B$2000;('CapLeg Fee Tracker'!$M$5:$M$2000<>””)*('CapLeg Fee Tracker'!$D$5:$D$2000>='Control Sheet'!$X$9)*('CapLeg Fee Tracker'!$D$5:$D$2000<='Control Sheet'!$X$10))
gives me a #Value error
Control sheet - cell X9 and X 10 sets out the date 1 April 2022 and 30 April 2022
CapLeg fee tracker – is the source document

Any assistance will be greatly appreciated.

 

[Toncar58]

The images are too large for the forum

 

[StephenCrump]

Your formula looks OK.

Check for #VALUE errors in 'CapLeg Fee Tracker'!$D$5:$D$2000 and 'CapLeg Fee Tracker'!$M$5:$M$2000.

These may cause a #VALUE error in your filtered results.

 

[Toncar58]

Your formula looks OK.

Check for #VALUE errors in 'CapLeg Fee Tracker'!$D$5:$D$2000 and 'CapLeg Fee Tracker'!$M$5:$M$2000.

These may cause a #VALUE error in your filtered results.

Thank you so much ... just seen the #VALUE errors in column "M"

 

[StephenCrump]

You're welcome. I'm glad we could help.