# Workday function like excel

Options

Hi, I want to use Workday function in Anaplan.

It is used in Excel.

But I can not imagine how calculate it.

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

Tagged:

• Options

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.

• Options

Why you explain weekday function ?

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