Forum Discussion

normabeez's avatar
normabeez
Brass Contributor
Feb 22, 2023
Solved

Calculating % Progress for Multiple Start and End Dates Formula

Hi All, My goal is to show the current percentage of progress between start and end dates.   Using the formula below works great, except I get the #NUM! error when a date is greater than today (...
Formulas and Functions
  • mtarler's avatar
    mtarler
    Feb 22, 2023

    normabeez  add that MIN() part you had previously:

    =IF(E14 < TODAY(),MIN((DATEDIF(E14,TODAY(),"d")+1)/(DATEDIF(E14,F14,"d")+1),1),0)
mtarler's avatar
mtarler
Silver Contributor
Feb 22, 2023

normabeez I think you were real close.  try:

 

=IF(E14 < TODAY(),(DATEDIF(E14,TODAY(),"d")+1)/(DATEDIF(E14,F14,"d")+1),0)

 

 

 or

 

=IFERROR((DATEDIF(E14,TODAY(),"d")+1)/(DATEDIF(E14,F14,"d")+1),0)

 

 

Resources