Forum Discussion
How to repeat date (dd/mm/yyyy) for x amount of rows, then the following day for the next x rows...
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 sa...
Hi Hans, thank you for your response; for some reason i am getting an error value when using either of these formulas. The value is written in the date format, what you think the issue may be?
See the attached demo workbook.
- Hans you are a lifesaver. If i were to change the number of rows, do I only switch out the 210 or is the portion with 2,1,0 also relevant? Thank you so much
You only need to change the value 210 to for example 70 or 100.
- Everything is working fine, except in cases where i manually enter dates for the first x rows (10, for example) and then want to implement the formula. For some reason, when using the formula with 75 as a divisor instead of 210, assuming the first 10 rows were copied manually, and I enter the formula in the 11th, it only repeats that first date for 25 rows, then the next dates are spread correctly (i.e., every 75 rows) if that makes sense. Not sure why that's happening.