Problem with dynamic employee sales table

Hi,

I have attached an example file. I am trying to build an dynamic/automated sales table, which depends on the date when an employee starts working. It is assumed that sales per employee is equal, but sales per month varies during the first 12-months.

The problem is that I haven't figured how to create function that starts automatically imputing sales when the employee starts working. For example:

In the Output sheet, if employee 2 starts working 1.2.2017, he sells 100 in the first month (1.2.2017), 200 in the second month (1.3.2017) etc. This incremental increase in sales is the same for each employee, only the start date varies. Rows before should naturally be blank as the employee has not started working.

I do not want to put these sales figures manually, but instead I want to create a dynamic table so that I can change inputs (1) employee start date (2) sales per month. Any tips how to build a function on sheet Output that takes this into account?

Thanks a lot in advance and please notice that there is nothing sensitive in the example file attached.

Hi JohnTopley,

thanks a lot for the function. However, I find this function problematic if I try to modify the length of sales period from 12-months to e.g. 16-months. Its starts to link incorrect figures to the output sheet (?).

Somehow it stats to show negative figures for Month (x) - Month (x), although they are positive as the date is still ascending..

I think this is a not a dynamic employee sales table. Why not sales maintain day wise in sales sheet. Output Monthwise as well as Emp wise. using simple formula sumifs. Look attach file.