+5 votes
91 views
Excel: Insert the current date

in Office by (552k points)
reopened | 91 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 (552k points) | 114 views
+3 votes
1 answer
asked Jan 3, 2022 in Office by backtothefuture (552k points) | 165 views
+4 votes
1 answer
asked Nov 14, 2021 in Office by backtothefuture (552k points) | 133 views
+4 votes
1 answer
asked Nov 14, 2021 in Office by backtothefuture (552k points) | 90 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users