Finding Latest Available Data

I知 trying to come up with a way to pick out the latest value based on a series of dates.

So for example, in Col A, I have a daily date series for the month of October. In Col B, I have data corresponding to those dates. However, during weekend dates, there is no data. I知 trying to figure out a formula to give me the latest available data.

Please see the attached Excel sample.

Some caveats:
- I cannot remove the weekend dates with no data
- I prefer not to use VBA / macros
- I prefer not to use array formulas but will do so if need be
- I am using Excel 2003

Thanks very much for any advice.