Automatically fill cell with a set value on specific calendar day and time

Question

On a given date and time in the calendar, I want to have a cell automatically filled in with a pre-set value. Example: I want the name "John Doe" to be entered into cell A1 in the excel file on March 1, 2023, at 8:00. How to approach this? Is macro required, or are there alternative methods as well?

Answer 1

 Use this formula:

=IF(NOW()>DATE(2023,3,1)+TIME(8,0,0),"John Doe","")