- Computers & Software»
- Computer Software»
- Office Software Suites»
- Microsoft Office
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.
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;
- 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
- Select Custom in the Category: list
- In the Type: box, enter y to show years, m to show the months and d to show days
- Click Ok
Find more free online Microsoft Excel training