Testing is only a snapshot in time... so getting a test 2-3 days before going to thanksgiving at granny’s house is only so effective.
Unless you are rapid testing people out in the driveway, (even then, there are false negatives) there isn’t a fool proof way to have gatherings