There’s a lot to do TODAY()

The following excerpt is taken from Chandoo’s blog on time and date functions. It’s just a bookmark post. All credits to him.

Staying at present:

  • To have latest star date in a cell, just press CTRL+; (of course, in Excel world, star date is nothing but whatever date your computer shows)
  • To have current time in a cell, just press CTRL+:
  • Of course, we time travelers are lazy.
Read the rest...