Percentage Past since start date & duration
Hi, I am looking for a formula to look at a percentage past based on the start date and the duration time. We are looking to see what the completed percentage should be and flag a WBS that may need to wither be updated or is falling behind.
I have worked out the formula for the # of days past since the start date, but that does not give me what I am after and when I change it into a % it goes to 300% which is not right.
=NETWORKDAYS([Start Date]@row, TODAY())
Any help would be great.
Help Article Resources
Check out the Formula Handbook template!