Feels simple enough, I have an excel file with employee data, and want to assign each employee an assessment date. There are alot of employees (around 6000). I want every 210 employees to have the same assessment date, then the following 210 employees to have the next day for their assessment (ideally using Egyptian business days). Is there a way to do this quickly?
Side note: the 6000 employees are also divided by department, so the number used above (210) is only used for the larger departments. Smaller departments will have smaller batches per assessment days and each department has its own sheet in the workbook. In the aggregate sheet, can I filter by department and assign assessment dates?
Assume the dates are to be put in column K
