Results 1 to 5 of 5

Percentage value shown in thousands upon progress calculation based on dates

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2013
    Location
    Poland
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    25

    Question Percentage value shown in thousands upon progress calculation based on dates

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Progress bar based on dates
    By ItsKingKongGG in forum Excel General
    Replies: 3
    Last Post: 01-27-2022, 04:07 AM
  2. [SOLVED] Progress bar based on dates
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-27-2020, 04:02 AM
  3. Calculate Percentage progress between two dates
    By SuperFlrares in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-30-2018, 11:16 AM
  4. [SOLVED] Current progress calculation based on dates
    By kriminaal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-29-2016, 04:13 PM
  5. [SOLVED] Percentage calculation Based on dates and remaining task 2013
    By Excelnoub in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-06-2014, 01:10 PM
  6. Data Table to be shown in Thousands
    By rmaa in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2013, 10:30 AM
  7. Progress bar or indicator to display calculation percentage
    By Dan27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2013, 01:13 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1