Return cell value if date is between two dates

[Lforeman]

	A	B	C	D	E
1	Job Number	Date	Amount	Week 1	Week 2
2				02/03/2019	09/03/2019
3				08/03/2019	15/03/2019
4	201	05/03/2019	3182.20
5	201	05/03/2019	2137.80
6	201	07/03/2019	4349.80
7	201	08/03/2019	2362.80
8	201	11/03/2019	2623.60

<tbody>
</tbody>

I need help please in determining the correct formula for returning a value if date is between two date.

The above data is an example of what I am working with.

In cell D4, I want to show the value of C4 if B4 falls within (and including) the date range of week 1 (D2 and D3).

All attempts have resulted in a false result.

 

[RasGhul]

Hi Lforeman,

If you want sum between dates & per Job number maybe you could use this?

Book1
	A	B	C	D	E	F	G
1	Job Number	Date	Amount		Job Number	Week 1	Week 2
2	Transactions					02-03-19	09-03-19
3						08-03-19	15-03-19
4	201	05-03-19	$3,182.20		201	$12,032.60	$2,623.60
5	201	05-03-19	$2,137.80
6	201	07-03-19	$4,349.80
7	201	08-03-19	$2,362.80
8	201	11-03-19	$2,623.60
Sheet1

Cell Formulas
Range	Formula
F4	=SUMIFS($C$4:$C$8,$B$4:$B$8,">="&F$2,$B$4:$B$8,"<="&F$3,$A$4:$A$8,$E4)
G4	=SUMIFS($C$4:$C$8,$B$4:$B$8,">="&G$2,$B$4:$B$8,"<="&G$3,$A$4:$A$8,$E4)

 

[sandy666]

maybe:

D4: =IF(AND($B4>=D$2,$B4<=D$3),$C4,0)

 

[Lforeman]

Thank you for your responses.

I have worked out that it is a report formatting problem not a formula problem. Sandy666 your formula worked, thank you.

 

[sandy666]

You are welcome

Have a nice day