Weekly Computer Tip # 356
18 December 2011


Countdown to your special day

Seven sleeps to go until Christmas and this will be the last tip for 2011. It's an oldie (tip 39 to be precise) but a goodie in case 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:

  1. Enter the date of the event (say, 25/12/11) in, say, cell A1
  2. Select cell B1 and type =TODAY()
  3. Select the cell in which the countdown result is to appear (say, C1) and type =A1-B1
  4. 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 your special day. (See 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.

K.

roem limited
software training and support

PS To cancel this subscription at any time, you may send an e-mail to: unsubscribe@roem.co.uk

PPS Feel free to reprint this tip (with full copyright and subscription information) in your newsletters and message boards. Got a tip to share? Submit it by emailing karen@roem.co.uk - if your tip is selected, I'll publish it along with your name; the bragging rights will last a lifetime.