I am looking for a solution/formula that will generate in a Multi-Select field all unique dates between ‘start date’ and ‘end date’.
I need that solution to generate a report with rollup fields and calculate the number of inhouse guests on specific dates, for exemple in hotel room management, or vehicles car rental.
Hi @Walid_Chaker - this might work for you. If you have an end and a start date, you can calculate the in-between dates in other fields, one date per column. This requires you to define the columns ahead of time and won’t work for any date range (specifically very long ranges greater in length than the number of columns you have defined), but if you know you ranges will be less than, say, 20 days, you can build columns to suit. Here is the set up for a date range of 5 days and you can extend as you see fit:
I am looking to do something similar but still having difficulty. I have a contract start date and end date MM/DD/YY. I am looking to create a formula to list all the months YYYY-MM into one column of that contract.
For example Start Date 12/11/20 and End date is 6/30/21. Then the next column would list. 2020-12, 2021-01, 2021-02, 2021-03, 2021-04, 2021-05, 2020-06
From there I want to that the full value of the contract say it is $14,000 and divide it by the number of months for a monthly amount, in this case $2,000 each month.
Then I would roll this up to another table called accrual and have the first column be Month, the next would be Monthly Accrual