Todays date in a cell

  • Thread starter Thread starter Sophie
  • Start date Start date
S

Sophie

Hi I have a spreadsheet that I use to record data. I only fill it in about
once or twice a week. What I want to do is when I open the spreadsheet I
want to have todays date in the cell below the last one i.e dates in column
A

However I then want the dates to stay as those dates i.e if I open the
spreadsheet on 07/07/03 with that date in cell A12 when I open the
spreadsheet on 09/07/03 I still want 07/07/03 in cell A12 and 09/07/03 in
A13 etc. What do I put in cell A2 and fill down the column?

Thanks Sophie
 
Try this but put the sheet you want and the cell you
want. If Date does not work on the righthand side try the
other one. You can change the way the date looks by
editing the part within the Format( ). Try looking in the
help menu for this. I am not sure if it has something in
there or not. I would put this in the same location the
other person told you to put the other code.

Worksheets("Sheet1").Range("D2").Formula = Date

or

date1 = Format(Now, "dd-mm-yy")
Worksheets("Sheet1").Range("D2").Formula = date1


Joe
 
Sophie, try entering "=NOW()" without the quotes.
Then format it as the Date format you like, ie
mmddyy or whatever...mmddyyyy is available at the bottom
of the Custom formatting list.
Of course this will change every time you open the
spreadsheet.
To FREEZE it,you can Edit Copy it
Edit Paste Special Values to remove the formula.
Of course you can record these procedures with the
Macro Recorder as well.
Hope this helps..
Jim
 
Back
Top