Automatically displaying a date

[Tom]

What function do I use so that a cell always shows the
current date?

 

[Dave R.]

=today()

 

[Marcotte A]

You can use the following VBA code to have the date appear in cell B3 the first time you open the spreadsheet (and then never change on subsquent days/opennings). I use it for a template of a daily order recap form. (Just make sure the user doesn't save over the template ;

Private Sub Workbook_Open(
If Sheets("master").Range("b3") = "" The
Sheets("master").Range("b3") = Dat
Els
End I
End Sub

 

[Gord Dibben]

Tom

=TODAY()

Gord Dibben Excel MVP