Multiple choice technology web technology

Converts a serial number to a day of the month

  1. DAYS

  2. DAY

  3. DAYS360

  4. DAYS365

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

The DAY function converts a serial number (date value) to the day of the month, returning a number from 1 to 31. This is different from DAYS which calculates day differences, or DAYS360 which uses a 360-day year convention. DAY extracts just the day component from a date.