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

[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 · Accepted solution]

@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

[JosephSerpis · Accepted solution]

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

[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?