If you need to find the day of the month on which events occurred from a list of dates in the named range of Start_Date, which formula would provide the correct result?
A)=DAYS(End_Date,Start_Date)
B)=DAYMONTH(Start_Date)
C)=IF(DAYMONTH(Start_Date)

Question

If you need to find the day of the month on which events occurred from a list of dates in the named range of Start_Date, which formula would provide the correct result?
A)=DAYS(End_Date,Start_Date)
B)=DAYMONTH(Start_Date)
C)=IF(DAYMONTH(Start_Date)<31,Start_Date,1)
D)=DAY(Start_Date)

Quizplus · Accepted Answer

The function DAY() returns the day of the month for a given date. Therefore, using DAY(Start_Date) would give the correct result. The other options either give incorrect information (A), are not a valid Excel function (B), or do not guarantee the correct result (C).

If You Need to Find the Day of the Month