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 …