Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Current date in cell

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  File Size In PP 2003 Vs PP2007  
Author Message
SS

External


Since: Dec 9, 2008
Posts: 5



(Msg. 1) Posted: Sat Jul 04, 2009 5:25 pm
Post subject: Current date in cell
Archived from groups: microsoft>public>excel (more info?)
How do I put a current date in cell, meaning a formula so that when I open
the spreadsheet the cell will have todays date in it.

4th July 2009


thanks

 >> Stay informed about: Current date in cell 
Back to top
Login to vote
Don Guillett

External


Since: Oct 18, 2008
Posts: 18



(Msg. 2) Posted: Sat Jul 04, 2009 5:25 pm
Post subject: Re: Current date in cell
Archived from groups: per prev. post (more info?)
=today()
in the cell but it will change with each day and calculate with any other
calculation.

Or, put in the ThisWorkbook module in the workbook_open event
sheets("yoursheetnamehere").range("yourrnage")=date

 >> Stay informed about: Current date in cell 
Back to top
Login to vote
Rick Rothstein

External


Since: Nov 18, 2008
Posts: 7



(Msg. 3) Posted: Sat Jul 04, 2009 5:25 pm
Post subject: Re: Current date in cell
Archived from groups: per prev. post (more info?)
You can use this formula to format the date as you have shown (with an
ordinal suffix)...

=DAY(NOW())&MID("thstndrdth",MIN(9,2*RIGHT(DAY(NOW()))*
(MOD(DAY(NOW())-11,100)>2)+1),2)&TEXT(NOW()," mmmm yyyy")

Since NOW() is a Volatile function, it would be more efficient to put this
formula in a cell...

=NOW()

and replace each of the 4 NOW() function calls in my formula with a
reference to that cell.
 >> Stay informed about: Current date in cell 
Back to top
Login to vote
SS

External


Since: Dec 9, 2008
Posts: 5



(Msg. 4) Posted: Sun Jul 05, 2009 6:25 am
Post subject: Re: Current date in cell
Archived from groups: per prev. post (more info?)
Thanks working good now.


"Rick Rothstein" wrote in message

> You can use this formula to format the date as you have shown (with an
> ordinal suffix)...
>
> =DAY(NOW())&MID("thstndrdth",MIN(9,2*RIGHT(DAY(NOW()))*
> (MOD(DAY(NOW())-11,100)>2)+1),2)&TEXT(NOW()," mmmm yyyy")
>
> Since NOW() is a Volatile function, it would be more efficient to put this
> formula in a cell...
>
> =NOW()
>
> and replace each of the 4 NOW() function calls in my formula with a
> reference to that cell.
>
> --
> Rick (MVP - Excel)
>
>
> "SS" wrote in message

>> How do I put a current date in cell, meaning a formula so that when I
>> open the spreadsheet the cell will have todays date in it.
>>
>> 4th July 2009
>>
>>
>> thanks
>>
>
 >> Stay informed about: Current date in cell 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Change 3rd cell colour based on cell 1 >= cell2 in range - Hi all - I have looked through the group for a solution to this particular problem but i think my inexperience is possibly stopping me from seeing the solution .. so apologies if it has already been answered many times previously. My problem is this : ...

Date in excel - When I start Excel I would like to set the system time automatic back. Something like this Read current date Set date to 25-12-9 start excel stop excel Set date to curret date Can anybody help with this ?

Cell references have changed??? - Hi All, For some reason my Excel has changed the cell references to another format, i.e. instead of being cell A1, it has changed to R1C1. Is there a way to change this back to be the cell references that I am use to dealing with? Thanks in advance!!

Getting cell value of composed address - I have a grid of data where I am trying to apply conditional formatting. The logic is that, for every cell in a column, if it's value matches what is in row 3 of that column then I want to apply the conditional formatting. So I have the following..

Extract different strings from a cell? - If I have "100BDDDABAABD" in a cell and I'd like to extract the last 10 characters and put each character into a different cells. Then, the first rest of characters (first 3 in this case) into another cell. How do I do that in Excel? Thanks,
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]