Q. Which Excel function extracts the year from a date?

A
MONTH()
B
YEAR()
C
DAY()
D
DATE()
Solution:

YEAR() extracts the year portion from a date value in Excel.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!