Tame your computer – countdown to Christmas

30 Sep

You might have used Excel’s TODAY worksheet function to automatically enter the current date. But did you know you can also use this Function to create a countdown to the given date of your upcoming events 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/12) 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 http://www.roem.co.uk/Xmascountdown.xls for an example.)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: