Excel Show Countdown Date

Excel Discussion in 'Microsoft Office' started by Merium, Sep 12, 2018.

  1. Merium

    Merium

    Joined:
    Sep 12, 2018
    Likes Received:
    0
    Hi,

    I'm stuck...Can someone please help? I'm trying to find a way of showing a future (Countdown Date).
    Each person is billable up to 1000. What date will the target of 60,000 be achieved?
    If today we have billed 9,331.29.....what date will we achieve the remaining 50,668.71?
    Screen Shot 2018-09-12 at 11.05.01.png

    I've attempted to draw out above what i'm trying to achieve, anyone know how i can do this automatically? With a countdown Date. (of working days)
     
    Merium, Sep 12, 2018
    #1
    1. Advertisements

  2. Merium

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,321
    Location:
    Manchester
    Welcome to the forum :)

    You could use this:

    =TODAY()+((J1-J4)/1000)

    Which assumes that the maximum billable amount of £1000 is achieved each day. Is this what you're looking for?
     
    Becky, Sep 12, 2018
    #2
    1. Advertisements

  3. Merium

    Merium

    Joined:
    Sep 12, 2018
    Likes Received:
    0
    Yes, the billable amount being 1000 every day. But the above formula doesn't work in giving the correct date.

    want to be able to pick up the achievable date when the target can be reached. In a countdown format.
    So the date is subject to change depending on if there was an billing.
     
    Merium, Sep 12, 2018
    #3
  4. Merium

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,321
    Location:
    Manchester
    How do you mean, you want the date in a count down format? Does that mean you want to know the number of days instead of the date? Do you have the cell formatting set to 'date'?
     
    Becky, Sep 12, 2018
    #4
  5. Merium

    Merium

    Joined:
    Sep 12, 2018
    Likes Received:
    0
    I have the cell set to Date & Time format. Yes i would like to have it displayed as DD MM YYYY : HH MM SS

    Showing the Date; Time counting down.
     
    Merium, Sep 12, 2018
    #5
  6. Merium

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,321
    Location:
    Manchester
    The date/time will only change when the 'Today Billing' figure changes. If you want a count down then you will need to show the number of days/hours/minutes etc until the target is achieved, not the date when the expected target will be achieved. Even then, you will need Excel recalculating almost constantly to show an active count down.

    You can use =NOW() to give the date and time right now, but as you will see it doesn't change until Excel recalculates it.
     
    Becky, Sep 12, 2018
    #6
  7. Merium

    Merium

    Joined:
    Sep 12, 2018
    Likes Received:
    0
    Yeah, thats not quite what i'm looking for. The date needs to be live / refreshed (but it needs to be in a countdown format) so counting down the days to when it will achieve 60,000. This would be determined based on the daily rate of 1000 and what the current billing is. Is this possible?
     
    Merium, Sep 14, 2018
    #7
  8. Merium

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,321
    Location:
    Manchester
    You seem to be wanting two separate things here; either you can have the date when the target will be achieved, or you can have the number of days counting down until the target is achieved. If you want a date counting down, this will only happen if the Today Billing figure is constantly changing.

    It is also worth bearing in mind that when Excel recalculates, it recalculates everything. So if you want a constant countdown you need Excel constantly recalculating everything on the workbook, which will slow down performance considerably.
     
    Becky, Sep 14, 2018
    #8
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.