Find Missing Dates From Referenced Table

[tjamal1]

Hello, 

I have table which contains Dates 

Calender Dates

1/1/2020

1/2/2020

1/3/2020

1/4/2020

1/5/2020

1/6/2020

1/7/2020

1/8/2020

1/9/2020

1/10/2020

1/11/2020

1/12/2020

I have another table which contains UserID and LogDates

UserID	Log Dates
1	1/1/2020
1	1/2/2020
2	1/3/2020
2	1/4/2020
2	1/5/2020
2	1/6/2020
2	1/7/2020
2	1/8/2020

Is there anyway to find the missing Dates By User

Missing dates are those which are not in User Table but present in Referenced Table

For example for user 1 it should be like 

UserID	MissingLogDates
1	1/3/2020
1	1/4/2020
1	1/5/2020
1	1/6/2020
1	1/7/2020
1	1/8/2020
1	1/9/2020
1	1/10/2020
1	1/11/2020
1	1/12/2020

[BrandonB · Accepted solution]

I would take the entire list of calendar dates that you expect, and the entire list of UserIDs, and append one to the other. This creates a master list of sorts which is the entire list of expected combinations. Then you can join it back to the UserIDs and Log Dates table on both the UserID and log date. The L or R on the side of the master list will show the combinations that do not exist in your main data set which I believe is what you are looking for.