# Show your Vacations Space?
**URL:** https://community.fibery.io/t/show-your-vacations-space/1188
**Category:** Fibery Showcase
**Created:** [November 20, 2020, 2:41pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188 "2020-11-20T14:41:51Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@aprotasenya](https://community.fibery.io/u/aprotasenya)
#### Post date: [November 20, 2020, 2:41pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/1 "2020-11-20T14:41:51Z")
Hi all! š
I was wondering if someone could show their customized Vacations App, as Iām looking into the ways and ideas to make the standard one better.
I have basic usage concerns, like āhow do I set the state holidays for everyone, how do I manage paid and unpaid leaves, how do I make formulas omit the weekendsā ā and I thought that everyone using it has probably dealt with these concerns in some way.
So I just wanted to ask: would someone want to show off their awesome customized Vacations App? š
---
### Author:  [@mdubakov](https://community.fibery.io/u/mdubakov)
#### Post date: [December 6, 2021, 2:13pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/2 "2021-12-06T14:13:02Z")
> [@aprotasenya](#):
>
> I have basic usage concerns, like āhow do I set the state holidays for everyone, how do I manage paid and unpaid leaves, how do I make formulas omit the weekendsā ā and I thought that everyone using it has probably dealt with these concerns in some way.
@antoniokov Is working on these problems right now and I hope he will share the space soon.
---
### Author:  [@mdubakov](https://community.fibery.io/u/mdubakov)
#### Post date: [December 6, 2021, 2:14pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/3 "2021-12-06T14:14:14Z")
BTW, here is the early MVP.
---
### Author:  [@aprotasenya](https://community.fibery.io/u/aprotasenya)
#### Post date: [December 6, 2021, 3:48pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/4 "2021-12-06T15:48:07Z")
Well, Iām tempted to re-type the arcane formulas by @Chr1sG right from the video right now!
Thanks for sharing! @antoniokov, Iām looking forward to picking that baby up right off your hands! š
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [December 6, 2021, 3:57pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/6 "2021-12-06T15:57:22Z")
S
```auto
If(WeekDayName(Dates.Start(),"dy") = "mon",0,If(WeekDayName(Dates.Start(),"dy") = "tue",1,If(WeekDayName(Dates.Start(),"dy") = "wed",2,If(WeekDayName(Dates.Start(),"dy") = "thu",3,If(WeekDayName(Dates.Start(),"dy") = "fri",4,If(WeekDayName(Dates.Start(),"dy") = "sat",5,6))))))
```
E
```auto
If(WeekDayName(Dates.End(),"dy") = "mon",6,If(WeekDayName(Dates.End(),"dy") = "tue",5,If(WeekDayName(Dates.End(),"dy") = "wed",4,If(WeekDayName(Dates.End(),"dy") = "thu",3,If(WeekDayName(Dates.End(),"dy") = "fri",2,If(WeekDayName(Dates.End(),"dy") = "sat",1,0))))))
```
Weekdays
```auto
(((((ToDays(Dates.End(false) - Dates.Start()) + S) + E) * 5) / 7) - If(S > 5,5,S)) - If(E < 3,0,E - 2)
```
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [December 6, 2021, 3:58pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/7 "2021-12-06T15:58:17Z")
We are considering adding a function to get the day as a number instead of text, which will make S and E much simpler š
---
### Author:  [@aprotasenya](https://community.fibery.io/u/aprotasenya)
#### Post date: [December 6, 2021, 5:02pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/8 "2021-12-06T17:02:23Z")
Thanks a whole lot!
---
### Author:  [@Jean](https://community.fibery.io/u/Jean)
#### Post date: [March 12, 2022, 12:29pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/9 "2022-03-12T12:29:07Z")
Can someone share a working template with holidays per country?
---
### Author:  [@mdubakov](https://community.fibery.io/u/mdubakov)
#### Post date: [March 29, 2022, 5:57pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/10 "2022-03-29T17:57:11Z")
I believe @antoniokov can do it, since we have it in our company
---
### Author:  [@aprotasenya](https://community.fibery.io/u/aprotasenya)
#### Post date: [May 23, 2022, 8:54am UTC](https://community.fibery.io/t/show-your-vacations-space/1188/11 "2022-05-23T08:54:57Z")
I have finally implemented the MVP shown in the video here. But my Public Holidays have DateRange instead of a single Date. @Chr1sG @antoniokov any chance you have a solution for this case or can help me with the formula? It would be a massive help, it takes me a lot of time to construct something like that. š
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [May 23, 2022, 9:50am UTC](https://community.fibery.io/t/show-your-vacations-space/1188/12 "2022-05-23T09:50:21Z")
The formulas above are intended to work with a date range. They assume that the field name is āDatesā but if you change that everywhere to whatever youāre calling your field, they should work fine.
e.g. change
```auto
If(WeekDayName(Dates.Start(),"dy") = "mon",0,If(WeekDayName(Dates.Start(),"dy") = "tue",1,If(WeekDayName(Dates.Start(),"dy") = "wed",2,If(WeekDayName(Dates.Start(),"dy") = "thu",3,If(WeekDayName(Dates.Start(),"dy") = "fri",4,If(WeekDayName(Dates.Start(),"dy") = "sat",5,6))))))
```
to
```auto
If(WeekDayName(YourFieldName.Start(),"dy") = "mon",0,If(WeekDayName(YourFieldName.Start(),"dy") = "tue",1,If(WeekDayName(YourFieldName.Start(),"dy") = "wed",2,If(WeekDayName(YourFieldName.Start(),"dy") = "thu",3,If(WeekDayName(YourFieldName.Start(),"dy") = "fri",4,If(WeekDayName(YourFieldName.Start(),"dy") = "sat",5,6))))))
```
and similarly for the other formulas.
---
### Author:  [@aprotasenya](https://community.fibery.io/u/aprotasenya)
#### Post date: [May 23, 2022, 3:23pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/13 "2022-05-23T15:23:22Z")
Thanks, Chris! But Iām not talking about the S & E formulas for the **Vacations** database. Iām talking about the date format for the **Public Holiday** database and the formula in Automation Rules that are used to connect **Public Holidays** to **Vacations**.
In Antonās example above it is simply a `Date` (e.g. Public Holiday āChristmasā has a date of `25-12-2021`), and he performs simple comparison to know if the **Public Holiday** falls in any **vacation** ās `DateRange`.
But my **Public Holidays** have `DateRanges` (e.g. Public Holiday āChristmasā has a date range of `25-12-2021 ā 27-12-2021`).
Therefore **Public Holidaysā** `DateRanges` have to be compared to **Vacationsā** `DateRanges`, which I canāt wrap my head around fast enough. š
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [May 23, 2022, 5:39pm UTC](https://community.fibery.io/t/show-your-vacations-space/1188/14 "2022-05-23T17:39:41Z")
I think Anton chose to make public holidays single dates because it is hard to calculate overlaps in date ranges.
I think I recall there were also some challenges if a vacation/holiday date range spanned two years (e.g. 30th Dec - 2nd Jan).
Anyway, Iām wondering why you are choosing not to use a single date field (and then define multiple holidays if the period is more than one day)?
---
### Author:  [@aprotasenya](https://community.fibery.io/u/aprotasenya)
#### Post date: [May 24, 2022, 7:51am UTC](https://community.fibery.io/t/show-your-vacations-space/1188/15 "2022-05-24T07:51:30Z")
I chose DateRanges because we use the term āStudio Holidayā instead of āPublic Holidayā ā and that also covers cases where we have a long holiday for the whole studio (say, Dec25-Jan10). I realize that having single dates works better because it works easier, but I really donāt like the idea of creating 16 one-day holidays. š
---
### Author:  [@antoniokov](https://community.fibery.io/u/antoniokov)
#### Post date: [September 6, 2022, 8:53am UTC](https://community.fibery.io/t/show-your-vacations-space/1188/16 "2022-09-06T08:53:12Z")
Iām a bit late to the party but I hope this is still helpful š
I chose single-date public holidays to avoid dealing with partial overlaps:
Iām pretty sure we can upgrade the solution to support date range holidays, but the complexity would skyrocket. Iād use a spreadsheet to slice a range into single dates instead:
Itās a once-in-a-year operation so it shouldnāt be much of a burden, even if dates shift. You can always add a container DB on top of the Public Holiday DB and set up an automation to move the holidays when their parent container moves.
---
### Author:  [@antoniokov](https://community.fibery.io/u/antoniokov)
#### Post date: [September 6, 2022, 9:02am UTC](https://community.fibery.io/t/show-your-vacations-space/1188/17 "2022-09-06T09:02:04Z")
Nudged by this discussion as well as a few conversations with our dear customers, weāve packed our vacation tracking solution into a proper template: [https://fibery.io/templates/vacations-pro](https://fibery.io/templates/vacations-pro).
On top of our regular [Vacations template](https://fibery.io/templates/vacations), this advanced template accounts for country-specific holidays and weekends. Hence, makes a report like the one we have on [Open Startup page](https://fibery.io/open-startup) possible:
An overview:
[ ](https://www.youtube.com/watch?v=RGEZebGwL0A)
A behind-the-scenes video for total nerds:
[ ](https://www.youtube.com/watch?v=UC0hZZVxbJI)