英文:
Automatically fill cell with a set value on specific calendar day and time
问题
我想在特定的日历日期和时间自动填写一个单元格,填写预设的值。
示例:
在2023年03月01日08:00,我希望在Excel文件的单元格A1中填写名称'John Doe'。如何操作?是需要宏还是还有其他方法?
注:笔记本将关闭,然后在浏览器中打开(如果这一点有关的话...)。然而,它将在我考虑自动填充文本的日期上打开。一个单元格是必须的,两个单元格是对我的问题的附加部分。
英文:
I want to automatically fill in a cell with a pre-set value on a specific calendar day and time.
Example:
On the 2023-03-01 at 08:00 I want the name 'John Doe' to be filled in cell A1 in excel file. How to go about this. Is it macro that is needed or are there other ways as well?
Edit: the Notebook will be closed down and its opened in a browser (if that even matters..). However, it will be opened on the date Im thinking of auto-filling text in a cell or two. One cell being a must, two cells being a bonus addition to my question.
答案1
得分: 1
=IF(NOW()>DATE(2023,3,1)+TIME(8,0,0),"John Doe","")
英文:
You can use a formula:
=IF(NOW()>DATE(2023,3,1)+TIME(8,0,0),"John Doe","")
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论