You didn't specify the logic very much so if I understood correctly, your update could be something like:
UPDATE Table2
SET Status = 'Active'
WHERE Table2.UserId IN (SELECT DISTINCT userid
from table1
WHERE date > DATEADD( day, -5, GETDATE()))
AND Table2.Status <> 'Active'
The above should update the status to active if the date in date column is greater than five days ago.
However if the status is dependent on nondeterministic value (such as current date, which constantly changes), I wouldn't advice to store the status, just to query the status when it's needed.