+5 votes
72 views
Excel: Insert the current date

in Office by (550k points)
reopened | 72 views

1 Answer

+3 votes
Best answer

Insert current date in Excel

Would you like to include today's date in an Excel document? No problem! We'll show you how to do it very easily..

image image

When using Microsoft Excel, it can make sense to include the current date. However, it is not necessary to enter the same date again and again by hand: there is a simple key combination for this.

Insert current date in Excel

You can insert the current date in Excel under Microsoft 365 using the key combination [Ctrl] + [;] . In older Office versions use the key combination [Ctrl] + [.] . The cell is then also written directly in the correct format. With Excel, the format of each cell can be adapted to its content.

image
In Excel, you can easily insert the current date.

=HEUTE() Alternatively, you can also enter in the corresponding cell . The date is then automatically included . The date is then adjusted each time the Excel document is opened so that it always relates to the current day. When you enter =JETZT() , the current date and time are also entered. These will also be updated..


by (3.5m points)

Related questions

+3 votes
1 answer
+3 votes
1 answer
asked Jan 1, 2022 in Guides by backtothefuture (550k points) | 93 views
+3 votes
1 answer
asked Jan 3, 2022 in Office by backtothefuture (550k points) | 133 views
+4 votes
1 answer
asked Nov 14, 2021 in Office by backtothefuture (550k points) | 103 views
+4 votes
1 answer
asked Nov 14, 2021 in Office by backtothefuture (550k points) | 70 views
Sponsored articles cost $40 per post. You can contact us via Feedback
10,627 questions
10,759 answers
510 comments
3 users