# Rango de fechas
**URL:** https://community.glideapps.com/t/rango-de-fechas/59218
**Category:** Ask for Help
**Created:** [March 15, 2023, 10:16pm UTC](https://community.glideapps.com/t/rango-de-fechas/59218 "2023-03-15T22:16:52Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@SombreArte\_Viales](https://community.glideapps.com/u/SombreArte_Viales)
#### Post date: [March 15, 2023, 10:16pm UTC](https://community.glideapps.com/t/rango-de-fechas/59218/1 "2023-03-15T22:16:52Z")
hello everyone.
I am making a time control app for my employees, I have my “registration” screen where I enter the employees in a “multiple selection” the status in a “single selection” I need a date range to appear when the status is “vacation” so that I fill the rows automatically with that state.
Since I currently enter date by date and I would like to avoid filling out employees who are on vacation every day
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 16, 2023, 1:28am UTC](https://community.glideapps.com/t/rango-de-fechas/59218/2 "2023-03-16T01:28:14Z")
> [@SombreArte\_Viales](#):
>
> I enter the employees in a “multiple selection” the status in a “single selection” I need a date range to appear when the status is “vacation” so that I fill the rows automatically with that state.
I’m not sure I understand this part fully. Can you give us an example of how your data structure looks like?
---
### Author:  [@SombreArte\_Viales](https://community.glideapps.com/u/SombreArte_Viales)
#### Post date: [March 16, 2023, 6:20pm UTC](https://community.glideapps.com/t/rango-de-fechas/59218/3 "2023-03-16T18:20:12Z")
Sorry, I’m bad at explaining.
Right now I have a screen in my app where I put a date, the employees and the status of these employees.
I need that when the status is “holidays” instead of adding day by day, I want it to fill in all those days automatically.
I imagine that I have to add the range between two dates to my spreadsheet for that to happen, but I don’t know how to do it.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 17, 2023, 1:11am UTC](https://community.glideapps.com/t/rango-de-fechas/59218/4 "2023-03-17T01:11:11Z")
So instead of having 3 rows for holidays of a person, let’s say from 18 Mar 2023 to 20 Mar 2023, you want it to be just 1 row, and specify the start date and end date?