Last week I wrote a London 2012 Olympics-themed post showing how to use Excel to flip a coin. Keeping in the Olympic spirit I thought I’d share a spreadsheet that helps you count down the number of days, hours, minutes and seconds between now and the opening ceremony.
It uses a simple macro to calculate each second, and you can adapt it to any deadline date and time, and to show either just workdays or all days. Beyond that I’ll let you explore the tool yourself and understand how it works.
When you open it you’ll need to enable macros, and then click the Countdown button on the bottom right of the Display tab.