ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

Countdown to the London 2012 Olympics in Excel

Updated on October 1, 2010

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.


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


    0 of 8192 characters used
    Post Comment

    No comments yet.