Fill rows according to date range

how are they?
Could you help me with this problem?
I am making an employee control application, which is recorded every day to have a daily record of each employee.
I currently have several employees who are on vacation and I have to record the same data every day.
I would like the days that you are on vacation to be filled in automatically by putting a “start date” and “end date” in the form.
Is this possible?

If you need it to be different rows and not just a “start date” and “end date” in a single row, then you might have to push this to an external service like Make/Zapier to loop through the list of dates and add rows one by one.