# Days on calendar

**URL:** <https://forum.adalo.com/t/days-on-calendar/20565>\
**Category:** Database\
**Created:** [December 8, 2021, 1:30pm UTC](https://forum.adalo.com/t/days-on-calendar/20565 "2021-12-08T13:30:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rene115](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rene115/32/3821_2.png) [@Rene115](https://forum.adalo.com/u/Rene115)\
**Post date:** [December 8, 2021, 1:30pm UTC](https://forum.adalo.com/t/days-on-calendar/20565/1 "2021-12-08T13:30:47Z")

</div>

Greetings, I am looking to make an airbnb-type booking app.  
I want to make reservations in a calendar and that each day has “a value - price” to be able to charge.  
for example Friday and Saturday the price is $ 50 higher than the others.

then then be able to make a ticket with the calculation of the amount of the reservation.  
How can I do to show an (amount to) if the user reserves during the week?  
and how to show (amount b) if you book on the weekend.

I want to be able to give value to each day!

I leave some captures …

 ![Captura_1](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/e/eb116918ddaebb3938a6d2659f67a1bc8e562baf.png)

 ![Ticket](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/4/4911c96d7892d5cda6d3253e110cf2e31387a388.png)

 ![total ticket](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/d15538cda35455d2e8ef34820319908bea0fc369.png)

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [December 8, 2021, 9:05pm UTC](https://forum.adalo.com/t/days-on-calendar/20565/2 "2021-12-08T21:05:43Z")

</div>

Hi @Rene115 ,

This is a hot topic.

To get the weekend days, you can check this post,

> [@How to derive weekdays from a date](https://forum.adalo.com/t/how-to-derive-weekdays-from-a-date/2374):
>
> If you need to derive the weekday from a date field or the Date Picker, you can use the following formula: [image] How does this work? When calculating with a date field we get a decimal number as a result. (see: [How to calculate with days and minutes](https://forum.adalo.com/t/how-to-calculate-with-days-and-minutes/2000)) For example: [image] The 7th of July 2020 is represented by the value 18449.9166. Where 18449 is the number of days since 1/1/1970 and the decimal 0.9166 a fraction of a day to represent the time. Adding 4 days In our formula we first ad…

Next, I suppose you will need to check for availability.

I am doing a replacement for date picker with custom list and soon will be integrated into my free template, Komun.

The benefit of doing in list is we have more control on how to show and to add actions with conditional, but we need to build calendar database which are inconvenient to most people, it adds more complexity than normal which they are trying to avoid by using no code tools.

But if you are the type of person that move forward with whatever the roadblocks are, I think booking function is achievable.

---

<div class="post-metadata">

**Author:** ![Rene115](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rene115/32/3821_2.png) [@Rene115](https://forum.adalo.com/u/Rene115)\
**Post date:** [December 14, 2021, 2:32am UTC](https://forum.adalo.com/t/days-on-calendar/20565/3 "2021-12-14T02:32:55Z")

</div>

very grateful for your answer. Well, I really only need to know what day of the week is to represent a price at the end.  
At first I thought to assign value to each day, but it will be easier just to simulate that knowing what day it is.

My interest is to know if it is Friday or Saturday with that I can already decide the visibility of the calculation.

really grateful and I’m going to test your formula.

---

<div class="post-metadata">

**Author:** ![Rene115](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rene115/32/3821_2.png) [@Rene115](https://forum.adalo.com/u/Rene115)\
**Post date:** [December 14, 2021, 3:31am UTC](https://forum.adalo.com/t/days-on-calendar/20565/4 "2021-12-14T03:31:22Z")

</div>

Great!!! I have tried the formula and I have solved the problem !! without a doubt very grateful !!!  
Greetings from El Salvador!!
