» Entering the Current Date into a Cell
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To enter the current date in a cell:
Select a cell and press Ctrl+;.
The formula that calculates the current date is:
=TODAY ()
Book Store:
Recommended Books:
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Financial Risk Manager Handbook, Second Edition
- The One Page Business Plan: Start With a Vision, Build a Company!
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
Does not work on my Laptop
Simon Posted on: 31-12-1969
But then I have to press the shift key and = to get a + and maybe this only works with a numeric key pad. But then the date will probably be in mm/dd/yy format for the first 12 days of the month and then in dd/mm/yy for the rest of the month, so not much use.It does
KAMBIZ Posted on: 31-12-1969
you shoul pess the Ctrl key and the ; key net the + key !=NOW()
Courtney Posted on: 31-12-1969
Also does this...That's right courtney
sean Posted on: 31-12-1969
It worked for me, it could work you you too.Automatically start a workbook
John Posted on: 31-12-1969
How do I get a workbook to start automatically when I start Excel?Reply: Automatically start a workbook - John from GB wrote on August 13, 2003 12:10 PM EST
Alan Posted on: 31-12-1969
Hi John,
I have seen this done many times, but it is extremely annoying to anyone else using that computer if they don't want that file, or even if the normal user doesn't.
My suggestion to colleagues who want this, is that they set up a shortcut immediately beside their normal Excel shortcut (within the Start Menu or on their Desktop normally), that actually refers to the file that you want to open up with normally.
That way, when they click on that shortcut, the workbook opens automatically with Excel without inconveniencing themselves or others who don't want it.
Hope that works for you.
Alan.
Start Of Month
Taiki Posted on: 31-12-1969
Is there a way to have excel change a given date (ie. 8/17/2003) to the start of that month?(8/1/2003) Thank you.Reply: Start Of Month - Taiki from California wrote on August 18, 2003 2:39 PM EST
Alan Posted on: 31-12-1969
Hi Taiki,
If you have a cell (A1) containing the date value for 17 Aug 2003 (=37850) then you can get to the value for 1 Aug 2003 by using the following formula:
=VALUE(TEXT(A1,"MMM YY"))
There are other ways, but this one is very general, and does not require the use of any 'unusual' functions etc.
Alan.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
