Finding data

New Contributor


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 Replies



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:





Many thanks.