Inserting the current date in Calc.

Discuss the spreadsheet application

Inserting the current date in Calc.

Postby princess » Sun Jul 11, 2010 5:57 am

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.
Last edited by princess on Wed Jul 14, 2010 1:53 am, edited 1 time in total.
OpenOffice 3.2 on Windows XP
princess
 
Posts: 4
Joined: Sun Jul 11, 2010 5:39 am

Re: Inserting the current date in Calc.

Postby acknak » Sun Jul 11, 2010 6:25 am

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.
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17399
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Inserting the current date in Calc.

Postby RoryOF » Sun Jul 11, 2010 6:41 am

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.
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14346
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Inserting the current date in Calc.

Postby acknak » Sun Jul 11, 2010 4:35 pm

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): search.php?st=0&sk=t&sd=d&sr=posts&keywords=+%2Bdate+insert++%2Bmacro

Or, check these specific threads for some ideas:
viewtopic.php?f=7&t=21237
viewtopic.php?f=9&t=24923
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17399
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Inserting the current date in Calc.

Postby MrProgrammer » Mon Jul 12, 2010 12:10 am

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.
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.6.8.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 1742
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Inserting the current date in Calc.

Postby vasa1 » Mon Jul 12, 2010 4:48 am

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.
LibreOffice 3.5.3.2 on Ubuntu 12.04
vasa1
 
Posts: 254
Joined: Sat Dec 26, 2009 1:20 pm
Location: Bombay

Re: Inserting the current date in Calc.

Postby kingfisher » Wed Feb 08, 2012 1:20 am

Just btw I only need to press Enter once.
OpenOffice 3.3 on PCLinuxOS. There are 3 kinds of people: those who can count and those who can't.
User avatar
kingfisher
Volunteer
 
Posts: 1861
Joined: Tue Nov 20, 2007 10:53 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 12 guests