TODAY and NOW in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get the current date in Google Sheets.

Google Sheets

= [1]()

Drag options to blanks, or click blank then click option'

ANOW

BTIME

CTODAY

DDATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using NOW() returns date and time, not just the date.

Using DATE() requires arguments and does not return current date automatically.

The TODAY() function returns the current date without the time.

2fill in blank

medium

Complete the formula to get the current date and time in Google Sheets.

Google Sheets

= [1]()

Drag options to blanks, or click blank then click option'

ATODAY

BNOW

CDATE

DTIME

Attempts:

3 left

💡 Hint

Common Mistakes

Using TODAY() returns only the date, not the time.

Using TIME() requires arguments and does not return current time automatically.

The NOW() function returns the current date and time, updating every time the sheet recalculates.

3fill in blank

hard

Fix the error in the formula to get the current date only.

Google Sheets

= [1]

Drag options to blanks, or click blank then click option'

ATODAY()

BTODAY

CNOW

DNOW()

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting parentheses after function names.

Using NOW() when only date is needed.

Functions in Google Sheets need parentheses () to work. TODAY() returns the current date.

4fill in blank

hard

Fill both blanks to create a formula that shows the current date and time, then adds 1 day.

Google Sheets

= [1]() + [2]

Drag options to blanks, or click blank then click option'

ANOW

BTODAY

C1

D24

Attempts:

3 left

💡 Hint

Common Mistakes

Using TODAY() adds only date without time.

Adding 24 adds 24 days, not hours.

NOW() gives current date and time. Adding 1 adds one full day (24 hours).

5fill in blank

hard

Fill all three blanks to create a formula that shows the current date, adds 3 days, and formats the result as text.

Google Sheets

= TEXT([1]() + [2], [3])

Drag options to blanks, or click blank then click option'

ATODAY

B3

C"yyyy-mm-dd"

D"hh:mm:ss"

Attempts:

3 left

💡 Hint

Common Mistakes

Using NOW() instead of TODAY() when only date is needed.

Forgetting to put quotes around the format string.

Using wrong format string for date.

TODAY() returns current date. Adding 3 adds three days. TEXT(..., "yyyy-mm-dd") formats the date as year-month-day.