Index & Match

[Harlequin]

Hello

I have a matrix on the sheet “Booking Sheet Matrix”, which consists of booking numbers & dates.

For each date (In column A) it shows along the Grid, what was booked for 8 days out.
Bookings that happen for the same day, on the same day. (For the 28/05/7, it was 618 bookings), are show in the sheet “MATCH”. (Col D)

What I need is.

For every day that bookings accured in the same day. (Columns C & D in the sheet “MATCH”), I need to have a formula that looks back at the previous days bookings, and shows the difference. (I have shown what answers I would expect in cells F30 : K32 , in the “MATCH” sheet.

Also.

If the date is Sunday, in the Matrix it is blank, the formula in “MATCH” sheet (Cells F5:K32), must ignore the zero, and take away the next day that had booking. ( ie in cell K30, it show take the booking for Sat 26th, that occurred on Mon 21st from Sat 19th, not Sun 20th.

Any help would be much appreciated.