Current date in cell

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

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
 
=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
 
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.
 
Thanks working good now.


Rick Rothstein said:
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.
Click to expand...
 
Back
Top