Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
2 years ago
Solved

Adding X Business\Working Days to another date.

I have a table (Time to Fill) with a date column (Position Opened) and want to create another column on the same table that displays 35 Business\Working Days from the "Position Opened" date, but afte...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    StuartSmith This depends on your logic. The way this is written, January 8th is working day +0, January 9th is working day +1 (from the Start Date). It seems you want to count the start date as the first working day. In that case, remove the +1 from the CALENDAR function so CALENDAR( [Start Date], [Start Date] + __Days)

     

     

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
2 years ago

Thanks, I have it working, of sorts, but as an example, the start date is Mondays 8th Jan and 35 Business days would be Fri 23rd Feb, but your script is doing Mon 26th Feb.  

 

35 Business Days From Position Opened =
    VAR DaysToFill = 35
    VAR __Days = DaysToFill * 4
    VAR __Calendar =
        FILTER(
            ADDCOLUMNS(
                CALENDAR( [Position Open Date] + 1, [Position Open Date] + __Days),
                "WeekDay",WEEKDAY([Date],2)
            ),
            [WeekDay] < 6
        )
    VAR __Table =
        ADDCOLUMNS(
            __Calendar,
            "Index", COUNTROWS(FILTER(__Calendar, [Date] <= EARLIER([Date])))
        )
    VAR __Result = MAXX(FILTER(__Table, [Index] = DaysToFill),[Date])
RETURN
    __Result
StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
2 years ago

Even you example file does the same...

What am i missing?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    StuartSmith This depends on your logic. The way this is written, January 8th is working day +0, January 9th is working day +1 (from the Start Date). It seems you want to count the start date as the first working day. In that case, remove the +1 from the CALENDAR function so CALENDAR( [Start Date], [Start Date] + __Days)