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
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...
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 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.