Finding data

%3CLINGO-SUB%20id%3D%22lingo-sub-2180568%22%20slang%3D%22en-US%22%3EFinding%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2180568%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20data%20showing%20my%20arrival%20and%20departure%20dates%20in%2Fout%20of%20the%20UK%20going%20back%20many%20years.%3C%2FP%3E%3CP%3ETable%201%20-%20Example%20data%20set.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20have%20a%20list%20of%20dates%20when%20I%20was%20in%20the%20UK.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Stephennn_0-1614741074062.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F260385i6345163BD9CFEAC2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Stephennn_0-1614741074062.png%22%20alt%3D%22Stephennn_0-1614741074062.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2180568%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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. 

Stephennn_0-1614741074062.png

Thanks for your help. 

2 Replies

@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:

 

JMB17_0-1614747006902.png

 

@Stephennn 

Many thanks.