Hi Folks,
I have a simple dilemma that I can't get resolved.
I want to calculate progress in percentages in Excel with a given start date and end date so that no progress shows as 0% and the complete progress shows max 100%.
What I get in the output is the percentage in thousands.
I have tried almost any solution offered by Google and ChatGPT, I changed Excel formula settings, tried different MIN/MAX combinations, cell formatting, etc.
Nothing helped.
This was not the case in my Excel, I used to get normal percentage values, not sure what happened.
Latest formula used:
=IF(TODAY() < A2, 0, IF(TODAY() > C2, 100, MIN((TODAY() - A2) / (C2 - A2) * 100, 100)))
- The example worksheet attached
Any advice is appreciated.
/Marat
Bookmarks