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.