The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function should you use to extract just 12?

The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function should you use to extract just 12?


a. =YEAR(C1)
b. =MONTH(C1)
c. =DAY(C1)
d. =DAYS(B1, C1)


Answer: c. =DAY(C1)


Learn More :