Countdown to the London 2012 Olympics in Excel

This hub will look at using Excel to create a countdown to the London 2012 Olympics. Everyday the countdown will automatically calculate how many years, months and days there are until the start of the Olympics.

Find Out How Many Days Remaining

To find out how many days there are until the start of the London 2012 Olympics, we will subtract today’s date from the date of the start of the Olympics.

For this example, the start date of the Olympics is entered in cell A1 of the spreadsheet, and the function =TODAY() is entered in cell B1.

Enter the formula below into a cell on the spreadsheet, and copy it across to the 2 cells to the right.

=$A$1-$B$1

Both cell references are absolute to fix the cells.

Format the Cells

Each cell now requires formatting to show the years, months and days. Select each cell and turn and format as below;

  1. Click Format > Cells in Excel 2003, or click the Dialogue Box Launcher button in the corner of the Number group on the Home tab in Excel 2007 and 2010
  2. Select Custom in the Category: list
  3. In the Type: box, enter y to show years, m to show the months and d to show days
  4. Click Ok

Find more free online Microsoft Excel training

Countdown until the London 2012 Olympics in  Excel
Countdown until the London 2012 Olympics in Excel

More by this Author

  • Sort Pictures in an Excel List
    0

    If you are using pictures in your Excel spreadsheet you may be having some difficulty with sorting the pictures along with the other data in the list. The good news is that you can sort pictures in an Excel list just...

  • Create an Interactive Excel Chart using Option Buttons
    6

    Form controls can be added to an Excel spreadsheet to create interactivity with the user. This article looks at using option button controls to allow a user to choose the data they want to see on a chart. The first...

  • Brock Lesnar Nutrition and Workouts
    2

    Brock Lesnar is a phenomenon of a man and an athlete. Brock Lesnar weighs a lean 265 lbs and yet possesses extreme speed, agility and athleticism. How a man carrying so much muscle mass can maintain such high levels of...


No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working