Hello - first time poster here. I've been trying to figure out how to model a schedule that breaks out Experienced and Inexperienced sales employees. For the first three months, after a new employee is hired, I would like them to be counted as an Inexperienced Seller, then in the 4th month and forward, they should be counted as an Experienced Seller. I'm trying to figure out rows 3 and 4 below.
Headings - columns for each month Jan - Dec
Row 1 - Currently, this counts the total number of sales employees (experienced and inexperienced) in each month by pulling data from a master hiring spreadsheet (The master hiring spreadsheet will be adjusted to suit hiring needs and should feed the rest of the model below)
Row 2 - Currently, this subtracts the previous month's count from the current month's count to get the count of new employees added that month
Row 3 - This should return the number of Experienced Sellers based on the criteria above, so only counting employees that have been employed for 3 months.
Row 4 - This should return the number of Inexperienced Sellers - less than 3 months experience.
Assumptions - new employees start on the first of the month.
Thanks in advance for the help!
Headings - columns for each month Jan - Dec
Row 1 - Currently, this counts the total number of sales employees (experienced and inexperienced) in each month by pulling data from a master hiring spreadsheet (The master hiring spreadsheet will be adjusted to suit hiring needs and should feed the rest of the model below)
Row 2 - Currently, this subtracts the previous month's count from the current month's count to get the count of new employees added that month
Row 3 - This should return the number of Experienced Sellers based on the criteria above, so only counting employees that have been employed for 3 months.
Row 4 - This should return the number of Inexperienced Sellers - less than 3 months experience.
Assumptions - new employees start on the first of the month.
Thanks in advance for the help!
