+ Reply to Thread
Results 1 to 4 of 4

Progress bar based on dates

  1. #1
    Registered User
    Join Date
    01-26-2022
    Location
    Mauritius
    MS-Off Ver
    Version 2112
    Posts
    2

    Progress bar based on dates

    Hi all

    I was wondering if it's possible to put a progress bar from a starting date to an ending date based on today's date(which will be updated daily)? So that everytime i update for today's date it update the progress bar automatically either by a graph like cell or percentage?

    Column J = Starting Date
    Column K = Ending date
    Column Q = Today's date (updated manually everyday)

    So will it be possible to insert a progression bar based on the dates in Column L?

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.68 - (22121100)
    Posts
    7,692

    Re: Progress bar based on dates

    have a read here
    you need to enter either today() in the cell or point to the cell where you type in today()
    https://www.howtogeek.com/howto/4567...al-formatting/
    Attached Files Attached Files
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    01-26-2022
    Location
    Mauritius
    MS-Off Ver
    Version 2112
    Posts
    2

    Re: Progress bar based on dates

    Worked perfectly. Thank you for your help!

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.68 - (22121100)
    Posts
    7,692

    Re: Progress bar based on dates

    you are welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate progress between two dates
    By rjyusmc2005 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2020, 10:50 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. Progress Tracker based on dates
    By pauldaddyadams in forum Excel General
    Replies: 6
    Last Post: 03-02-2017, 01:24 PM
  5. [SOLVED] Current progress calculation based on dates
    By kriminaal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-29-2016, 04:13 PM
  6. Need formula: progress (% completion) between two dates
    By bsafra1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2014, 09:53 AM
  7. [SOLVED] Conditional Formatting - Progress Bar based on dates in row
    By RichTea88 in forum Excel General
    Replies: 3
    Last Post: 01-24-2013, 08:50 AM

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