Project217
New Member
- Joined
- Mar 7, 2022
- Messages
- 24
- Office Version
- 365
- Platform
- MacOS
Hi.
Just trying to cap the percentage at 100% it will currently go past 100%
The code is =IFERROR((DATEDIF(M10,TODAY(),"d")+1)/(DATEDIF(M10,N10,"d")+1),"0%")
This gives me a percentage required for a task completion of the date entered in cells M10 and N10
Any Help Would Be Greatly appreciated
Just trying to cap the percentage at 100% it will currently go past 100%
The code is =IFERROR((DATEDIF(M10,TODAY(),"d")+1)/(DATEDIF(M10,N10,"d")+1),"0%")
This gives me a percentage required for a task completion of the date entered in cells M10 and N10
Any Help Would Be Greatly appreciated