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.
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
Answers
-
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.
0 -
Why you explain weekday function ?
I want to identify 2 workdays later. So I have to consider national holiday.
0
