Search code examples
exceldata-comparison

Distribute a fixed range of dates within the same ID

I have a table that lists hotel reservations by ID, each with a check in and check out dates. I can sort this by ID, but I need to distribute (on a separate column) each day of the stay (Starting with the check in date and excluding the check out date).

I hope the file in the link below explains what I mean (The intended result column is listed as "Target")

https://www.dropbox.com/s/p0dt285lnntne7k/CHALLENGE.xlsx

Thank you so much in advance!

Solution

  • Please try: 

    =IF(A1=A2,D1+1,B2)

    in D2 and copied down to suit.