Price Per Date

There is a price list by date range.

9/1/2020..9/30/2020     $400

10/1/2020..blank             $500

I would like to have report for price base on the date. I have tried 

=NL("Rows","Purchase Price","Purchase Price","Item No.","@@"&$G8,"Starting Date","<"&$E8,"Ending Date",">"&$E8)

But it did not work exactly what i want. If the ending date is blank, it did not work.Please help.


Please sign in to leave a comment.