Return cell value if date is between two dates

[Lforeman]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Job Number
[/TD]
[TD]Date
[/TD]
[TD]Amount
[/TD]
[TD]Week 1
[/TD]
[TD]Week 2
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]02/03/2019
[/TD]
[TD]09/03/2019
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]08/03/2019
[/TD]
[TD]15/03/2019

[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]201
[/TD]
[TD]05/03/2019
[/TD]
[TD]3182.20
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]201
[/TD]
[TD]05/03/2019
[/TD]
[TD]2137.80
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]201
[/TD]
[TD]07/03/2019
[/TD]
[TD]4349.80
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]201
[/TD]
[TD]08/03/2019
[/TD]
[TD]2362.80

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]201
[/TD]
[TD]11/03/2019
[/TD]
[TD]2623.60
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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