Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculating Expected Due/Completion Date Time based on SLA & Created Date Time

Hi, Looking for a help on DateTime Caculation. I have a table with Unique Tasks Ids and its allocated dateTime and each of it has an SLA in days defined. I need to create every Task's expected Com...
  • Anonymous's avatar
    Anonymous
    6 years ago

     

    QUOTIENT = QUOTIENT(WEEKDAY(Test[Allocate DateTime],1)+Test[SLA Days],7)
    Expected End Date = Test[Allocate DateTime]+Test[SLA Days]+2*Test[QUOTIENT]
     
    Thanks,
    Pravin
Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

QUOTIENT = QUOTIENT(WEEKDAY(Test[Allocate DateTime],1)+Test[SLA Days],7)
Expected End Date = Test[Allocate DateTime]+Test[SLA Days]+2*Test[QUOTIENT]
 
Thanks,
Pravin
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Anonymous   It worked perfect !