Help : Sort & Filter

Please find attached file,

I want to sort my Hotel's group booking but with the detail on the row
How to sort the date of arrival only without changing the detail room.

thanks a bunch

I would write in I3 formula:
=IF(D3<>"",D3,ROUNDDOWN(I2,0))+ROW(I2)/100000

it returns an arrival date (taken either directly form column D or from above cell) and add a small number proportional to row number
rounddown is used to have a date only before adding)

now you can mark all columns including I and sort on I.
See attachment.

As I understand, the problem is solved, so please mark thread as SOLVED. See http://www.excelforum.com/forum-rule...rum-rules.html for how-to instructions.