Section 12, Activity 17, 201: Intermediate Model Building

Josh Elwood from Northeast sub-region joined the company on 2/5/15. He turned active and headcount:1, tenure:1, ramp:0.05, ramp status: 0.05, quota: 3,125 started in February per my formulas. However, he was considered as active, and headcount:1....started from March per video lecturer.  Therefore, it had affeacted the result for Sub-region Quota Module in section 13.  

My formulas: 

Headcount formula: IF Quota>0 THEN 1 ELSE 0

Active?: 

IF ISBLANK(Rep Setup.Start Date) THEN FALSE ELSE IF Rep Setup.Start Date > END() THEN FALSE ELSE IF ISNOTBLANK(Rep Setup.End Date) AND Rep Setup.End Date < START() THEN FALSE ELSE TRUE

Tenure:

IF NOT Active? THEN 0 ELSE IF YEAR(START()) - YEAR(Rep Setup.Start Date) = 0 THEN MONTH(START()) - MONTH(Rep Setup.Start Date) + 1 ELSE 12 - MONTH(Rep Setup.Start Date) + (YEAR(START()) - YEAR(Rep Setup.Start Date)) * 12 - (12 - MONTH(START())) + 1

Hope someone could shed the light. Thank you.  -Debbie