TODAY and NOW functions in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get the current date in Excel.

Excel

= [1]()

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

ATODAY

BTIME

CNOW

DDATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using NOW() when only the date is needed.

Trying to type the date manually instead of using the function.

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 Excel.

Excel

= [1]()

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

ATODAY

BNOW

CDATE

DTIME

Attempts:

3 left

💡 Hint

Common Mistakes

Using TODAY() when time is needed.

Forgetting to format the cell to show time.

The NOW() function returns the current date and time.

3fill in blank

hard

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

Excel

= [1]()

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

ANOW

BTIMEVALUE

CDATEVALUE

DTODAY

Attempts:

3 left

💡 Hint

Common Mistakes

Using NOW() which includes time.

Using DATEVALUE or TIMEVALUE incorrectly.

Use TODAY() to get the current date without time.

4fill in blank

hard

Fill both blanks to create a formula that adds 5 days to today's date.

Excel

= [1]() [2] 5

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

ATODAY

B+

C-

DNOW

Attempts:

3 left

💡 Hint

Common Mistakes

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

Using minus sign instead of plus.

Use TODAY() to get the current date and add 5 days with +.

5fill in blank

hard

Fill all three blanks to create a formula that shows the current time only.

Excel

= [1]() - INT([2]()) + [3]

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

ANOW

C0

DTODAY

Attempts:

3 left

💡 Hint

Common Mistakes

Using TODAY() which has no time.

Not subtracting the integer part to remove the date.

This formula extracts the time from NOW() by subtracting the integer part (date) and adding zero.