IF date value returned from Index/Match is blank, return prior cell that returns a value

Hi all,

I have set up the attached spreadsheet to track sales in relation to selling days. An Index/Match formula is setup to return a value of how many selling days have progressed based on looking up the actual day of the month minus one day, and matching the month .

My problem is, when it looks up a day that is not a sales day (blank cell) by referencing L2, it doesnt return a value. I need a formula which says if a blank value is returned when matching the day in L2, return the value of the most recent selling day. This would be the prior cell with a value in it.

Eg. September 14 returns a blank, I need it to return the value for September 12 (the most recent selling day)

All help appreciated

Cheers