Welcome. Is there a formula or code that can do this, but only when opening the file every morning, because I may open it several times a day?
VBA Code:
Private Sub Workbook_Open()
Sheet1.[A1] = Sheet1.[A1] + 1
End Sub