Hello, I'm using the following formula to calculate the progress between two dates. =(DATEDIF(F9,TODAY(),"d")+1)/(DATEDIF(F9,G9,"d")+1) F9 is the Start Date and G9 is the End Date. However, this formula returns a #NUM error if the Start Date is greater than today. Does anyone know whether a modification to this formula using the IFERROR function to return a blank or 0% would work or if is there any other workaround? Thanks!!!
Bookmarks