Forum Discussion

creativekat26's avatar
creativekat26
Copper Contributor
Jun 30, 2023

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...
  • leoperdia's avatar
    leoperdia
    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.

Resources