IF OR THIS

[Nixson]

I need formula for below,

F1, IF D1 IS BLANK AND C1 LESS THAN IN BETWEEN FROM 01.01.2020 TO 31.01.2020 THEN B2 NEED TO APPEAR OTHERWISE 0
F1, D1 HAVE DATE AND IT IS BETWEEN 01.01.2020 TO 31.01.2020 THEN VALUE SHOULD APPEAR OR 0

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G
1						31/01/2020	28/02/2020
2	1	500	05/01/2020			500	0
3	2	200	08/08/2019	05/02/2020		0	200
4	3	300	05/05/2020			0	0
5	4	1500	01/03/2020			0	0
6	5	2800	05/12/2019			0	0
Master

Cell Formulas
Range	Formula
F2:G6	F2	=IF($D2<>"",IF(AND($D2<=F$1,$D2>EOMONTH(F$1,-1)),$B2,0),IF(AND($C2<=F$1,$C2>EOMONTH(F$1,-1)),$B2,0))

 

[Nixson]

THANKS

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Nixson]

HI,

Could you please help me for below,

i need formula for to get month wise due & month wise Payment done. if due Payment done it shourl reflect Payment done month wise or Payment due month wise.

 

[Fluff]

As this is a different question, you will need to start a new thread. Thanks