People who only exercise on weekends have a similar risk of developing mild dementia to those who work out more frequently, a new study has found.