Current date in cell

[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

 

[Don Guillett]

=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

 

[Rick Rothstein]

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.

 

[SS]

Thanks working good now.

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.