1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

An Excel Questions

Discussion in 'Business Applications' started by overdrawnprocess, Oct 9, 2008.

Thread Status:
Not open for further replies.
  1. overdrawnprocess

    overdrawnprocess Thread Starter

    Joined:
    May 11, 2007
    Messages:
    106
    Is there any way to have a date count down?

    Like I want one of the fields to be a value that keeps going down as it reaches a date. Such as if the date was Oct 17 today it's 8 and tomorrow it's 7 because it adjusted for the date. I don't know if that possible though.
     
  2. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    62,972
    First Name:
    Chuck
    An easy way is to use one cell to store the target date (10/17/2008). If you put the target date in cell B1 and want the countdown in cell B2, the formula to put in cell B2 would be:

    Code:
    =B1-TODAY()
    Format cell B2 to be a number with zero decimal places

    If you don't wish to use a separate cell for the target date, you can put this formula in B2

    Code:
    =39738-TODAY()
    Where October 17, 2008 is the 39,738th day since day 1 of January 1, 1900
     
  3. Pedro15

    Pedro15

    Joined:
    Oct 5, 2008
    Messages:
    386
    I used this macro for the attached file

    Sub Macro1() Do PauseTime = 1 ' Set duration. Start = Timer ' Set start time. Do While Timer < Start + PauseTime DoEvents ' Yield to other processes. Loop Range("B2:B9").Calculate Loop End Sub

    Also used formula for time and date.

    Pedro
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/757657

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice