Forum Discussion
How to calculate multiple due dates using Sumif and Workday functions
Hello, I am trying to calculate the due date for multiple projects based on an indicator. The deadlines are tracked by weekdays only. I attempted to achieve this by using the function below. Exce...
=IFS([@Indicator]=0,WORKDAY([@[Assigned Date]],10),[@Indicator]=1,WORKDAY([@[Assigned Date]],14))
This formula works in my sheet.
=IFS([@Indicator]=0,WORKDAY([@[Assigned Date]],10),[@Indicator]=1,WORKDAY([@[Assigned Date]],14))
This formula works in my sheet.
- Thanks for this! the only difference between our formulas is I closed the WORKDAY function in parenthesis (which should not matter. When I removed the parenthesis to match your function it worked! might be a weird bug? Do you get the same result?
Either way, thank you for the reply! You just saved me a pretty major headache!=IFS([@Indicator]=0, (WORKDAY([@[Assigned Date]],10)) ,[@Indicator]=1,
(WORKDAY([@[Assigned Date]],14)) )
You are welcome! If i put the WORKDAY function in parenthesis like above (highlighted in red) it works. I have to remove the equal sign before the WORKDAY function otherwise it doesn't work. I think in the other formula the closing parenthesis of the WORKDAY function are after [@[Assigned Date]] and should be after ,10) and after ,14).
- Yes! you are totally right! I hadn't noticed that I left the equal sign before the WORKDAY function, and forgot to close parenthesis after 10 and 14. I am still getting the hang of writing functions inside functions in Excel.
Thank you again for your support!
