Need Formula - Total # of "Working Days" Left
Hello and thanks in advance for your help! I would like to automatically calculate the total # of "working days" left (as of today) by referencing the Due Date. I did find a formula for total number of all days left "=[Due Date]23 - TODAY()" but I haven't been able to find one that just calculates working days. Here is some background so you know what I am trying to do:
I have a column denoting the estimated # of hours left on a given task (row) that I adjust manually as I go. I want to be able to divide that by # of days left to give me the number of hours that I will need to dedicate to that task each day "as of today" to make sure I make my due date.
Here's the formula that I am using to get the number of hours I will need to work each day as of today to reach my end date goal:
=[Est Hours Left]3 / ([# Days Left]3 * 8) * 8
Without the formula I am requesting here, I will have to go into each task each day and do a manual adjustment and I am hoping to automate that piece.
Thanks again for your help!
Help Article Resources
Check out the Formula Handbook template!