Apache OpenOffice Community Forum

In Calc, How do I insert the current date in the active cell. In Excel this can be done by clicking the ; + Ctrl key. Can this be done in a similar way in Calc?

I'm still working on this. I may just type in the days date.

Unfortunately, no.

The easiest way to insert the current date is by typing it.

If typing it is a problem, there are macros floating around that can--with some effort--give you a shortcut key for entering the current date.

Or checking Insert / Function List displays the list of functions on screen and you can restrict this to various categories of function by the top dropdown selector. Double clicking an item on the list will insert that item into the current cell.

This has come up many times before, and there are many ways to accomplish this--only you can decide which is best for you.

You can start with a search (click for the results): http://user.services.openoffice.org/en/ ... ++%2Bmacro

Or, check these specific threads for some ideas:
http://user.services.openoffice.org/en/ ... =7&t=21237
http://user.services.openoffice.org/en/ ... =9&t=24923

On 22 Nov 2009 Villeroy wrote:Easiest: Remember today's day number (22) and type it with "/" appended: Type 22/
Easy: Type =today() F9 Enter Enter

I'd recommend using one of those. On my system, the day number (today is 11) is always visible on the screen, so the first idea works great for me.

MrProgrammer wrote:

On 22 Nov 2009 Villeroy wrote:Easiest: Remember today's day number (22) and type it with "/" appended: Type 22/
Easy: Type =today() F9 Enter Enter

I'd recommend using one of those. On my system, the day number (today is 11) is always visible on the screen, so the first idea works great for me.

While I mostly use the first, the F9 one (second method) is a neat trick! Thanks.

Just btw I only need to press Enter once.

Hi.
In LibreOffice you can set a custom keyboard shortcut for date insertion: Go to Tools>Customize>Keyboard, and on the bottom search for Insert>Current Date