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
- In
B1, show today's date. - In
B2, work out how many days ago this member joined. - 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.