TEXT formatting for dates in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to format the date in cell A1 as "MM/DD/YYYY".

Google Sheets

=TEXT(A1, "[1]")

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

AMM/DD/YYYY

BYYYY/MM/DD

CDD-MM-YYYY

DHH:MM:SS

Attempts:

3 left

💡 Hint

Common Mistakes

Using dashes instead of slashes

Using lowercase letters which are not recognized

Confusing month and day order

The format "MM/DD/YYYY" shows the month, day, and year in that order, separated by slashes.

2fill in blank

medium

Complete the formula to display the date in cell B2 as "Friday, January 1, 2021".

Google Sheets

=TEXT(B2, "[1]")

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

Ayyyy-mm-dd

Bdddd, mmmm d, yyyy

Cdd/mm/yyyy

Dddd, mm dd, yyyy

Attempts:

3 left

💡 Hint

Common Mistakes

Using "ddd" which shows abbreviated weekday

Using "mm" which shows month as number

Using day with leading zero

"dddd" shows the full weekday name, "mmmm" the full month name, "d" the day without leading zero, and "yyyy" the full year.

3fill in blank

hard

Fix the error in the formula to show the date in C3 as "Jan 01, 2021".

Google Sheets

=TEXT(C3, "[1]")

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

Ammm dd, yyyy

Bmmmm dd yyyy

Cmm dd, yyyy

Ddd mmm yyyy

Attempts:

3 left

💡 Hint

Common Mistakes

Using "mmmm" which shows full month name

Missing commas in the format

Using "mm" which shows month as number

"mmm" shows the abbreviated month name, "dd" the day with leading zero, and "yyyy" the full year with commas as shown.

4fill in blank

hard

Fill both blanks to format the date in D4 as "2021-01-01 14:30" (24-hour time).

Google Sheets

=TEXT(D4, "[1] [2]")

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

Ayyyy-mm-dd

Bhh:mm AM/PM

CHH:mm

Dmm/dd/yyyy

Attempts:

3 left

💡 Hint

Common Mistakes

Using "hh" which is 12-hour format

Using slashes instead of dashes in date

Including AM/PM when 24-hour time is needed

"yyyy-mm-dd" formats the date with dashes, and "HH:mm" formats the time in 24-hour format without AM/PM.

5fill in blank

hard

Fill all three blanks to format the date in E5 as "Saturday, 01-Jan-21".

Google Sheets

=TEXT(E5, "[1], [2]-[3]-yy")

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

Adddd

Bdd

Cmmm

Dmm

Attempts:

3 left

💡 Hint

Common Mistakes

Using "ddd" which shows abbreviated weekday

Using "mm" instead of "mmm" for month

Using "yyyy" instead of "yy" for two-digit year

"dddd" shows full weekday name, "dd" shows day with leading zero, and "mmm" shows abbreviated month name. The year is shown as two digits with "yy".