Sale value of previous date

[#1]

If the date is missing and if it is selected then i want the sales value of the previous date.

eg.

sales value of 8/1/12 is missing so when i select dis date i want previous date's sales value.

Please help

[#2]

Hi,

  Please find the attached file. For  u r solution.