Multiple choice technology web technology

Converts a date in the form of text to a serial number

  1. DATE

  2. DATEVALUE

  3. DAYS360

  4. DGET

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DATEVALUE converts a date stored as text into a serial number that Excel recognizes as a date. This is useful when importing data or working with dates that are formatted as text strings. DATE itself constructs a date from numeric components.

Keep practicing — related questions