Workday function like excel

hyudolee

Hi, I want to use Workday function in Anaplan.

It is used in Excel.

 

In this page,  we can built using a calculation.

But I can not imagine how calculate it.

 

 

 

https://help.anaplan.com/d61d7264-24d0-4357-adc6-64701b16c9aa-Excel-comparison:-W-functions

 

 

Do you have any idea?

 

Date

1/1

1/2

1/3

1/4

1/5

1/6

1/7

1/8

1/9

1/10

1/11

1/12

After 2 Workday

1/4

1/4

1/5

1/6

1/7

1/10

1/11

1/11

1/11

1/12

Holiday

☑

☑

☑

☑

 

 

 

----------------------------------------------

I could calculate it by using movingsum function.

 

Do you have any other method to calculate it. 

 

After_Workday: 

 IF MOVINGSUM(Num_Workday, 1, 1) = Num_After_Workday THEN START() + 1 ELSE IF MOVINGSUM(Num_Workday, 1, 2) = Num_After_Workday THEN START() + 2 ELSE IF MOVINGSUM(Num_Workday, 1, 3) = Num_After_Workday THEN START() + 3　・・・・　Else blank

hyudolee

Why you explain weekday function ? 

I want to identify 2 workdays later.  So I have to consider national holiday.