Hi Guys, I need help on the following. So I have a separate calendar ALL DATES 2024-07-01 2024-07-022024-07-032024-07-042024-07-052024-07-082024-07-092024-07-102024-07-112024-07-12 Separately, I have a start date and number of days. START DATEDAYS2024-07-0922024-07-027 i need to count the days from the start date in the separate calendar, so it should be like this START DATEDAYSEND DATE2024-07-0922024-07-112024-07-0272024-07-10

Count specific a specific number within a separate calendar

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

Developer

Accepted answers

dwstada

@DanielCarro oh I understand, try this workflow. is it possible that your wanted output is wrong for 2024-07-02? Seven days added to that from your first date list is 2024-07-11

DanielCarro.yxmd

JosephSerpis

Hi @DanielCarro here is another way to tackle your ask. Essentially you need to combine your calendars together then caculate the end date

Screenshot 2024-09-19 164412.png

Count_Days_19092024.yxmd

All comments

dwstada

use a formula tool to create the END DATE column with this formula:

DateTimeAdd([START DATE], [DAYS], "days")

START DATE has to be a date type and DAYS has to be an integer type

apathetichell

Join Start Date on All Days -> then use a formula tool with datetimeadd to create End Date?

DanielCarro

Hi @dwstada ,

The end date has to come from the specific calendar as this one has no weekends. Don't use the normal calendar.

dwstada

@DanielCarro oh I understand, try this workflow. is it possible that your wanted output is wrong for 2024-07-02? Seven days added to that from your first date list is 2024-07-11

DanielCarro.yxmd

JosephSerpis

Hi @DanielCarro here is another way to tackle your ask. Essentially you need to combine your calendars together then caculate the end date

Screenshot 2024-09-19 164412.png

Count_Days_19092024.yxmd

DanielCarro

Hi @dwstada , @JosephSerpis ,

02/07- 1

03/07- 2

04/07- 3

05/07- 4

08/07- 5

09/07 - 6

10/07 - 7

DanielCarro

Hi @dwstada , @JosephSerpis ,

Your findings are correct. My apologies on my previous comment. Both workflows work perfect.

DanielCarro

Hi guys,

The workflows failed when applied to the other records.

dwstada

could you give any more information on what failed?

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.

Capture 20 Sep 2024.JPG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703