It depends on the designed exercise. Typically, an exercise without any previous information about an organization, could take a minimum of 3 months to obtain results. This however will represent the real situation of the defensive layers. Meanwhile other exercises starting with a certain level of access to internal resources could require less time.
Mature organizations tend to hire continuous red teaming operations, allowing them to perform several exercises during the year.