Newbie: trying to return cell contents if date is less than and greater than...

DV

I'm new at this.

Let's say these are my three columns:

Open Balance | AR Due Date | WK 1

 

So in the WK1 cell I want this formula:

If the AR Due Date is greater than 01/01/2018 and less than 01/07/2018, then return the value of Open Balance.

I've tried, but keep getting errors. Thanks for your help.

 

L_123

=IF([AR Due Date]1 > DATE(2018, 1, 1), IF([AR Due Date]1 < DATE(2018, 1, 8), [Open Balance]1, ""), "")

DV

Thank you!