Weekly Computer Tip # 324
11 December 2010
Countdown to Christmas (Excel 2003-2007)
Fourteen sleeps to go until Christmas and I am well aware that by this time next week I would get hundreds of out of office messages so this will be the last tip for 2010. It's an oldie (tip 39 to be precise) but a goodie if you want to create a countdown to a particular date such as a holiday, anniversary, birthday, wedding, retirement, completion of house ... or Christmas!
Here's how:
- Enter the date of the event (say, 25/12/03) in, say, cell A1
- Select cell B1 and type =TODAY()
- Select the cell in which the countdown result is to appear (say, C1) and type =A1-B1
- If necessary, right-click over cell C1, select Format Cells and choose General (from the Number tab)
If you save the file as normal you can check every day how many days are left between now and Santa's arrival. (See http://www.roem.co.uk/Xmascountdown.xls for an example.)
That's it for this year. Thank you for being supporters of my weekly tip. Have a great Xmas and look forward to helping you next year.
PS I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.
Home
Training
Support
Clients
Contact Details
News
Disclaimer