I have a formula that calculates how many hrs I have to go to finish a project. Looking for a formula that tells me the finish day if I average say 9 hrs each work day (M-F) I know it should be simple but can't seem to get it to work in a single simple calculation. Any help?
Goal = 3,000
I have a formula that calculates earned hrs of 1,951 which leaves 1049 hrs to go. 1049 hrs divided by 9 per day = 116.5 days.
If I use NOW() + 116.5 it gives me the actual date of completion, but that, I assume, includes the weekends. How do I push it out to only count weekdays?
Bookmarks