You need to sign in to do that
Don't have an account?
Sourav P
How to remove the week-ends and holidays from a Task aging field
Hi,
I have a task againg field , formula as below ( type " number")
I have a task againg field , formula as below ( type " number")
LastModifiedDate - CreatedDateBut i want to exclude the sat-sun and a public holiday list from this number. May i know how to modify the formula ? thnx
Hope this would work Replace 'Holiday Date' with the public Holiday dates, if there are more than one public holidays, the for each date there will be a 'IF' condition similar to the one at the end of the above formula.
Kindly mark this as solved if the reply was helpful.
Thanks,
Nagendra