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
More by this Author
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...
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...
If you are using Microsoft Project to schedule and track your projects, at some point you will probably want to export your project data into Excel. Excel can then be used to analyse and summarise your project data...
No comments yet.