Is it possible to protect data that are seven days or older so they cannot
be altered anymore after the period expired while new data can still be
entered?

if (Date-DateCell.Value)6 then
DateCell.Locked=True
end if

Remember idiotic Excel behaviour: to protect cells you need to set
Sheet protection (with empty password to activate cells protection
only)