Count specific a specific number within a separate calendar

[DanielCarro]

Hi Guys,

I need help on the following.

So I have a separate calendar

ALL DATES
2024-07-01
2024-07-02
2024-07-03
2024-07-04
2024-07-05
2024-07-08
2024-07-09
2024-07-10
2024-07-11
2024-07-12

Separately, I have a start date and number of days.

START DATE	DAYS
2024-07-09	2
2024-07-02	7

i need to count the days from the start date in the separate calendar, so it should be like this

START DATE	DAYS	END DATE
2024-07-09	2	2024-07-11
2024-07-02	7	2024-07-10

[DanielCarro]

Hi @dwstada ,

On your workflow the data appears as:

Record ID     START DATE             DAYS      END DATE

1                     2024-07-02              7           2024-07-11

At my end, the same item appears the following

Record ID     START DATE             DAYS      END DATE

 7                    2024-07-02              7           2024-07-04   ( to  be:2024-07-11)

43                   2024-07-30              1           2024-07-30    (to be:2024-07-31)

17                   2024-07-09              2           2024-07-10     (to be: 2024-07-11)

[dwstada]

@DanielCarro it is pretty hard to debug this without seeing the workflow, but my guess is that the sort before using the record id tool is not working correctly and therefore not giving the dates in the correct sequence. So make sure that you are correctly sorting your ALL DATES column

[DanielCarro]

Hi @dwstada @JosephSerpis ,

So I managed to make it work. I used the append and then a combination of two multi row formula and does the job perfect. Thank you for your help.