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

 

[LegendaryAxe]

Is this what you're looking for?

Book2
	A	B	C	D	E
2	date	description	debit	credit
3	1-Jul-24	jul rent	16500		paid
4	1-Aug-24	aug rent	16500		paid
5	1-Aug-24	24-Jul		16500
6	1-Sep-24	sep rent	16500		paid
7	3-Sep-24	24-Aug		16500
Sheet1

Cell Formulas
Range	Formula
E3:E7	E3	=IF(TEXT(A3,"mmm")=LEFT(B3,3),"paid","")

 

[shamsu203]

Is this what you're looking for?

Book2
	A	B	C	D	E
2	date	description	debit	credit
3	1-Jul-24	jul rent	16500		paid
4	1-Aug-24	aug rent	16500		paid
5	1-Aug-24	24-Jul		16500
6	1-Sep-24	sep rent	16500		paid
7	3-Sep-24	24-Aug		16500
Sheet1

Cell Formulas
Range	Formula
E3:E7	E3	=IF(TEXT(A3,"mmm")=LEFT(B3,3),"paid","")

I want to include the year also from both columns as the dates starts from 1jan 22

 

[LegendaryAxe]

That can be done, but currently some of the cells in column B don't contain years.

 

[shamsu203]

column b will not necessarily have months and year in all cells. the format of the sheet as shown. column b shows the date when payment was made eg jul 24 . the other discription shown is for which the money is due eg b2 July rent due. hope I am clear

 

[shamsu203]

column b will not necessarily have months and year in all cells. the format of the sheet as shown. column b shows the date when payment was made eg jul 24 . the other discription shown is for which the money is due eg b2 July rent due. hope I am clear

column b will not necessarily have months and year in all cells. the format of the sheet as shown. column b shows the date when payment was made eg jul 24 . the other discription shown is for which the money is due eg b2 July rent due. hope I am clear

 

[shamsu203]

to clarify u will notice A1 has 1 jul 24 which match b 5 datejul24. so e 3 will show Paid

 

[Shloime]

to clarify u will notice A1 has 1 jul 24 which match b 5 datejul24. so e 3 will show Paid

In B5 you have 24-Jul 24 is the day not the year

 

[Shloime]

something like

=if(sumifs($D:$D,$B:$B,">="&$A3,"<="&EOMONTH($A3))=$C3,"Paid","")

 

[shamsu203]

something like

=if(sumifs($D:$D,$B:$B,">="&$A3,"<="&EOMONTH($A3))=$C3,"Paid","")

getting message you have entered to few agruments for this function