Bird
Raised Fist0
Google Sheetsspreadsheet~5 mins

TODAY and NOW in Google Sheets - Cheat Sheet & Quick Revision

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Recall & Review
beginner
What does the TODAY() function return in Google Sheets?
The TODAY() function returns the current date without the time. It updates automatically each day when you open or refresh the sheet.
Click to reveal answer
beginner
What is the difference between TODAY() and NOW() functions?
TODAY() returns only the current date (year, month, day).
NOW() returns the current date and time (hours, minutes, seconds).
Click to reveal answer
intermediate
How often do TODAY() and NOW() update their values?
Both TODAY() and NOW() update automatically when you open or edit the sheet.
They do not update every second unless the sheet recalculates.
Click to reveal answer
intermediate
How can you use TODAY() to calculate someone's age if their birthday is in cell A1?
Use the formula: =INT((TODAY()-A1)/365.25) to get the age in years.
This subtracts the birthday from today and divides by 365.25 days to account for leap years.
Click to reveal answer
intermediate
What format does NOW() return and how can you display only the time?
NOW() returns date and time as a number with decimal part representing time.
To show only time, format the cell with a time format like hh:mm:ss or use =TEXT(NOW(), "hh:mm:ss").
Click to reveal answer
What does the TODAY() function return?
ACurrent time only
BCurrent date and time
CCurrent date only
DStatic date entered manually
Which function gives you the current date and time in Google Sheets?
ANOW()
BDATE()
CTIME()
DTODAY()
If you want to calculate how many days have passed since a date in cell A1, which formula is correct?
A=NOW() - A1
B=NOW() + A1
C=A1 - TODAY()
D=TODAY() - A1
How often do TODAY() and NOW() update their values?
AEvery second automatically
BOnly when you open or edit the sheet
CNever update after entering
DEvery hour automatically
Which formula shows only the time part of the current date and time?
A=TEXT(NOW(), "hh:mm:ss")
B=NOW() - TODAY()
C=TEXT(TODAY(), "hh:mm:ss")
D=TIME(NOW())
Explain how the TODAY() and NOW() functions work and when they update.
Think about how your phone clock updates when you open an app.
You got /4 concepts.
    Describe a real-life example where you would use TODAY() in a spreadsheet.
    Think about how you check dates on a calendar or planner.
    You got /4 concepts.

      Practice

      (1/5)
      1. What does the TODAY() function return in Google Sheets?
      easy
      A. The current date and time
      B. The current time without the date
      C. The current date without the time
      D. A fixed date set by the user

      Solution

      1. Step 1: Understand the purpose of TODAY()

        The TODAY() function returns the current date only, without any time information.

      2. Step 2: Compare with other functions

        NOW() returns both date and time, so it is different from TODAY().

      3. Final Answer:

        The current date without the time -> Option C

      4. Quick Check:

        TODAY() = current date only [OK]
      Hint: TODAY() shows date only, no time included [OK]
      Common Mistakes:
      • Confusing TODAY() with NOW()
      • Expecting time to be included in TODAY()
      • Thinking TODAY() returns a fixed date
      2. Which of the following is the correct way to write the formula that shows the current date and time in Google Sheets?
      easy
      A. =NOW()
      B. =TODAY()
      C. =CURRENT()
      D. =DATE()

      Solution

      1. Step 1: Identify the function for current date and time

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

      2. Step 2: Check other options

        TODAY() returns only the date; CURRENT() and DATE() are invalid or require parameters.

      3. Final Answer:

        =NOW() -> Option A

      4. Quick Check:

        NOW() = current date and time [OK]
      Hint: Use NOW() for date and time, TODAY() for date only [OK]
      Common Mistakes:
      • Using TODAY() to get time
      • Typing CURRENT() which is not a valid function
      • Using DATE() without parameters
      3. If cell A1 contains the formula =NOW() and cell A2 contains =TODAY(), which of the following is true about their outputs?
      medium
      A. A1 shows date only; A2 shows date and time
      B. Both show date only
      C. Both show date and time
      D. A1 shows date and time; A2 shows date only

      Solution

      1. Step 1: Understand outputs of NOW() and TODAY()

        NOW() returns current date and time; TODAY() returns current date only.

      2. Step 2: Match outputs to cells

        Cell A1 with =NOW() shows date and time; A2 with =TODAY() shows date only.

      3. Final Answer:

        A1 shows date and time; A2 shows date only -> Option D

      4. Quick Check:

        NOW() = date & time, TODAY() = date only [OK]
      Hint: NOW() includes time, TODAY() does not [OK]
      Common Mistakes:
      • Swapping outputs of NOW() and TODAY()
      • Expecting TODAY() to show time
      • Thinking NOW() shows date only
      4. You entered =TODAY (without parentheses) in a cell. What will happen?
      medium
      A. It will show an error
      B. It will show the current time
      C. It will show the text '=TODAY'
      D. It will show the current date

      Solution

      1. Step 1: Check function syntax

        Functions in Google Sheets require parentheses, even if empty, so =TODAY is incomplete syntax.

      2. Step 2: Result of missing parentheses

        Without parentheses, Google Sheets returns an error indicating invalid formula.

      3. Final Answer:

        It will show an error -> Option A

      4. Quick Check:

        Functions need () to work, else error [OK]
      Hint: Always include () after function names [OK]
      Common Mistakes:
      • Omitting parentheses for functions
      • Expecting function to work without ()
      • Typing function name as text
      5. You want to create a spreadsheet that shows the current date and time in cell A1 and updates automatically every time the sheet recalculates. Which formula should you use and why?
      hard
      A. =TODAY() because it updates date and time automatically
      B. =NOW() because it updates date and time automatically
      C. =NOW() but it only updates when you manually refresh
      D. =TODAY() but it only updates when you open the sheet

      Solution

      1. Step 1: Identify function that returns date and time

        NOW() returns both current date and time, while TODAY() returns only date.

      2. Step 2: Understand update behavior

        NOW() updates automatically when the sheet recalculates, showing fresh date and time.

      3. Final Answer:

        =NOW() because it updates date and time automatically -> Option B

      4. Quick Check:

        NOW() updates date & time automatically [OK]
      Hint: Use NOW() for auto-updating date and time [OK]
      Common Mistakes:
      • Using TODAY() expecting time updates
      • Thinking NOW() updates only on manual refresh
      • Confusing update triggers for TODAY()
      Recommended

      Ready to prove it?

      Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

      10 questions~5 mineasy hard