Entering Dates And Time In Excel


Q. Is there a quick way to enter dates and times in an Excel spreadsheet?

A. To enter the current date, select a cell and press Ctrl+; (that’s Ctrl and then the semicolon). To enter the current time, use Ctrl+: (the colon).

These shortcuts work even when you are entering formulas. For instance, let’s say you wanted to have today’s date as a string (within quote marks) in a formula. Enter your formula, up to the first quote mark, type Ctrl+; and the date appears in the formula. Type your closing quote mark, and continue with your formula.

However, if you’re going to use the time shortcut, be sure the internal clock on your computer is correct, because they are notorious for losing or gaining time. I once had a nifty little program that measured the drift error rate and then automatically corrected the time whenever I booted up. Unfortunately, I accidentally left that application behind in a discarded computer and haven’t been able to replace it. If anyone knows of a similar program, please let me know and I’ll share it in this column.

To obtain the exact time in your time zone, go to www.time.gov/timezone .

If you want to automatically synchronize the exact time with your computer’s internal clock, go to http://winfiles.cnet.com/apps/98/clock.html . The site contains many shareware and freeware programs that do the job.

SPONSORED REPORT

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.