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

KirillKuznetsov

@hyudolee 

Weekday function returns number from 1 to 7 (1 for Monday, 2 for Tuesday, and so on) https://help.anaplan.com/a445eb44-98b7-4abc-8748-92435187e423-WEEKDAY

Using this you can define weekends. For holidays you would need some storage of dates or mark them in time schedule as you did in your example.

Then you can use previous, next, lag, lead, offset functions to get some offset result.