Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Set Due Date based on working days

Hi everyone,    I need to calculate a Due Date column based on a given date and working days.    I am working with tickets issue in a given date-time that have to be completed before a due date b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

Thank you for your answer.

 

That's not exactly what I am looking for. You are calculating the number of working days based in an end date. I need to do the opposite, calculate the end date based on the number of working days.

 

My scenario is the following: I get jobs issued with different OLAs (1, 3, 5 or 7 working days), so I need to calculate the date when the jobs are due to organise the workforce to meet as many OLAs as possible. So I need to create a calculation that given the date the job was issued and the number of working days of its OLA, I could get the date the job is due:

 

           Due Date = fx ( Date issued, Number of working Days)

 

Best regards, 

 

Vaillo

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

So you mean you want to calculate max deadline based on current date and working days?


If this is a case, you can try to use below formula:

 

Max available deadline =
VAR _workingDays = xxxx
VAR _nonWorkingDays =
    COUNTROWS (
        FILTER (
            CALENDAR ( Table[Start], Table[Start] + _workingDays ),
            WEEKDAY ( [Date], 2 ) > 5
        )
    )
RETURN
    Table[Start] + _workingDays
        + _nonWorkingDays

 

 

Regards,

Xiaoxin Sheng