Workday function like excel

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.

 

hyudolee_0-1645682164042.png

 

 

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

 

 

Do you have any idea?

 

Date1/11/21/31/41/51/61/71/81/91/101/111/12
After 2 Workday 1/41/41/51/61/71/101/111/111/111/12  
Holiday        

 

 

 

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

I could calculate it by using movingsum function.

 

hyudolee_0-1645669738083.png

hyudolee_1-1645669776708.png


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

Answers