How long is too long for houseguests to stay?

With the holidays on the horizon, many people will be hosting houseguests - but how long is too long for those guests to stay?