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