Need help creating a custom duration formula
Hi! I need help with a formula to automatically update the "duration" column each day as well as only count weekdays and not weekends. Is this possible?
Here is some more information.
There is a "date submitted" column.
A "status" column with three options: Not started, In progress, and Complete.
There is a "duration" column. This column is meant to record the number of days since a request was submitted. This number should update daily until the "status" column is marked "complete."
Thank you for your assistance!
Help Article Resources
Check out the Formula Handbook template!