matching debit and credit based ondate

[shamsu203]

I have this worksheet where column a is date (range name datessfi) column bis description column c is debit (range name Debitsfi) and column d isCredit(range name creditsfi).
I want to show in column e paid against the date in column a when the month and date in column b(date format MMM_YY) matches the date in column b. eg in the attached worksheet the highlighted cells are self explanatory. any suggestion

date	description	debit	credit
1 Jul 2024	jul rent	16500		paid
1 Aug 2024	aug rent	16500		paid
1 Aug 2024	Jul-24		16500
1 Sep 2024	sep rent	16500
3 Sep 2024	Aug-24		16500

 

[Shloime]

getting message you have entered to few agruments for this function

sorry

=IF(SUMIFS($D:$D,$B:$B,">="&$A3,$B:$B,"<="&EOMONTH($A3,0))=$C3,"Paid","")