The impact and management of symptoms experienced at midlife: a community‐based study of women in northeast Scotland