Range.Formula Property (Excel) - MSDN - Microsoft

If you set the value or formula of a cell to a date, Microsoft Excel verifies that cell is ... example sets the formula for cell A1 on Sheet1 to display today's date. VBA.

msdn.microsoft.com