Forum Discussion
Solved
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...
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 Meaby I do not get you correctly, but the formula I've shared in the previous post is a combination of both:
IFERROR(MIN(1; (DATEDIF(B4;TODAY();"d")+1)/(DATEDIF(B4;C4;"d")+1));"not started")
The example I've shared is using this formula. The behavior is the following:
-If range date in the future--> not started
-If today is within the range date---> % of progress
-If range date in the past--> 100%
Regards
https://www.upwork.com/freelancers/~01cf0fc8446b00f44c
It is not recognizing this string as a formula
IFERROR(MIN(1; (DATEDIF(B4;TODAY();"d")+1)/(DATEDIF(B4;C4;"d")+1));"not started")
it's thinking its just plain text. am I missing something?
IFERROR(MIN(1; (DATEDIF(B4;TODAY();"d")+1)/(DATEDIF(B4;C4;"d")+1));"not started")
it's thinking its just plain text. am I missing something?
- Strange.....did you include "=" at the beginning of the formula?.. I mean....."=IFERROR(MIN..."
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
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.
