Forum Discussion
creativekat26
Jun 30, 2023Copper Contributor
calculating percentage between two dates
Hello - I am trying to show a percentage complete between two dates. I am using the formula: =MIN(1, (DATEDIF(B2,TODAY(),"d")+1)/(DATEDIF(B2,C2,"d")+1)) which is working great and leaves the p...
- Jun 30, 2023
creativekat26 I think the problem is the separators between the function arguments. The example I've provided is ";"(this is my separator). If you have ","(comma) as a separator please replace ";" with "," in my formula.
creativekat26
Copper Contributor
yes I did. I can't figure out what I'm doing wrong.
=IFERROR(MIN(1; (DATEDIF(B2;TODAY();"d")+1)/(DATEDIF(B2;C2;"d")+1));"not started")
This formula gives me this error
leoperdia
Jun 30, 2023Brass Contributor
creativekat26 I think the problem is the separators between the function arguments. The example I've provided is ";"(this is my separator). If you have ","(comma) as a separator please replace ";" with "," in my formula.
- creativekat26Jun 30, 2023Copper ContributorIT WORKED!!!!!!!!!!!!! Thank you SOOOOOOOOOOOO Much!
- leoperdiaJun 30, 2023Brass Contributor