leighsha101
New Member
- Joined
- Mar 20, 2023
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to sort out how to determine what percent of a project is complete. I can figure out calculating the percent of days between two dates using this formula: =(DATEDIF([@[Start Date ]], TODAY(),"d")+1)/(DATEDIF([@[Start Date ]], [@[Due Date ]], "d")+1). But, this doesn't account for weekends. I know how to find number of days excluding weekends using the NETWORKDAYS.INTL. What I can't figure out, is how to make these calculations together. How do I determine what percent of a project is done, based on today's date, but excluding any weekend days.
Please help!
I am trying to sort out how to determine what percent of a project is complete. I can figure out calculating the percent of days between two dates using this formula: =(DATEDIF([@[Start Date ]], TODAY(),"d")+1)/(DATEDIF([@[Start Date ]], [@[Due Date ]], "d")+1). But, this doesn't account for weekends. I know how to find number of days excluding weekends using the NETWORKDAYS.INTL. What I can't figure out, is how to make these calculations together. How do I determine what percent of a project is done, based on today's date, but excluding any weekend days.
Please help!