Hi,
Need help!!
I need to know the date when we need to close the ticket and we have Friday and Saturday off. The simple workday.intl formula works however the situation is that if an email is received on a Friday or Saturday (Non working) it should be counted from Sunday as T0.
Example: Email on 05-Jun-2020 (Friday) should be considered as received on 7-Jun-2020 which is T0 and TAT is 3days so my target to complete will be 10-June-2020.
I tried =WORKDAY.INTL(F2-1,3,7) however for the weekdays it gave incorrect value.
Bookmarks