- Worldstart's Tech Tips Newsletter - http://www.worldstart.com -

Open Office: Insert Today’s Date

Posted By On July 19, 2010 @ 11:05 AM In MS Office Help | Comments Disabled

Recently a reader sent in a question looking for an easy way to enter today’s date in a worksheet cell.

 Good question.

 I first went looking for something as simple as a quick key combination – but alas, I did not find one.

 But as I researched the issue I did find something that isn’t too time consuming.

 As you might expect, it’s a formula, but a simple one that you just can’t forget.

 To insert the current date in a Calc worksheet cell use

 =Today( )

 (I actually found that it would work with our without the space between the parenthesis – you choose.)

 Now, as a bonus, I also ran across the formula for the current date and time.

 =Now( )

 I didn’t find one for just the current time but I did find that if I used the Now formula in a cell formatted for a time then just the time was given.

 There you go – an easy way to mark your OpenOffice Calc worksheets as being in the “Here & Now”… or maybe I should say the “Today & Now”.

 ~April

Article printed from Worldstart's Tech Tips Newsletter: http://www.worldstart.com

URL to article: http://www.worldstart.com/open-office-insert-todays-date/