Finding data

[Stephennn]

Hi,

I have data showing my arrival and departure dates in/out of the UK going back many years.

Table 1 - Example data set. 

I would like to have a list of dates when I was in the UK. 

Thanks for your help. 

[#2]

@Stephennn 

I believe you could use Countifs for that. Create a list of dates for Table 2 (enter a few dates and then drag the fill handle down and it will increment the dates for you). Then, enter the countifs formula as shown below, adjusting range references as needed:

[#3]

@Stephennn 

Many thanks.