|1||Job Number||Date||Amount||Week 1||Week 2|
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.