Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 2/6

TODAY: the current date

Exercise 1 of 3

In B1, show today's date.

About this lesson

TODAY returns the current date and updates every day, which is useful for ages, deadlines and countdowns.

In this lesson

  1. In B1, show today's date.
  2. In B2, work out how many days ago this member joined.
  3. You open the file again tomorrow. What happens to =TODAY()?

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B1 and press Enter to check.