When I tried to join and create days a difference between two dates (don’t have any missing value here) using difftime, there are some rows that have NA and others are just fine. There are two things that I notice: