Determine if a Date is Between two dates then return that date

[DRDBRuss]

I have alist of dates on one tab (Calculations)in monthly intervals, on another tab (InterestSplits) I have a list of dates. I want to put the date from the second tabnext to the date on the first tab that the date is between.

I have tried the following IF statement but this does notreturn to the desired result:
=IFS('Interest Splits'!F3:F373,'InterestSplits'!F3:F373,">="&A12,'InterestSplits'!F3:F373,"<="&A13,'Interest Splits'!A3:A373,B1)
As I have multiple client data, the section of the formula'Interest Splits'!A3:A373,B1 determineswhich client I am looking against.

 

[Special-K99]

Try

=SUMPRODUCT(('Interest Splits'!A$3:A$373=B1)*(YEAR('Interest Splits'!F$3:F$373=YEAR(A12)*(MONTH('Interest Splits'!F$3:F$373=MONTH(A12)))
and copy down the column

 

[DRDBRuss]

Thanks Special-K99, unfortunately that didn’t seem to work.I probably didn’t explain it very well.
Below are some cut down examples of the data from each tab

To use an example, the result I expect to see is: when I put1 in cell B1 on the Calculations tab, the dates on the Interest Splits tab toappear next to the date range they are between. So 16/10/2014 should appear incell B13 and 08/07/2015 should appear in cell B22.

I’ve tried numerous formula but none seem to work for me !!
Interest Splits:

				Int Received
Key	Cust Name	Plan No	CONCAT	Amount	Date
1​				609.89​	06/10/2014​
1​				2344​	08/07/2015​
2​				1151.06​	06/10/2014​
2​				4689​	08/07/2015​
3​				1354.74​	25/03/2014​
3​				970.97​	01/07/2014​
3​				981.64​	06/10/2014​
3​				981.64​	14/01/2015​
3​				1930​	07/07/2015​

<tbody> </tbody>

Calculations:

Key	1​
Date (Expected)	Date (Actual)
03/07/2014​	X
30/09/2014​
31/10/2014​
30/11/2014​
31/12/2014​
31/01/2015​
28/02/2015​
31/03/2015​
30/04/2015​
31/05/2015​
30/06/2015​
31/07/2015​

<tbody> </tbody>