Excel Date and Time Functions Quiz-2

1. How to get the 01-Jan-2021 using EOMONTH function if the start date is 25-Dec-2020?

2. Select any one function, which helps us to calculate the number of working days between 2 dates with Friday and Saturday as week-offs.

3. Select the correct formula using below start date to get the result using EDATE Function.

Start Date:01-Dec-2020

Result: 06-Dec-2021

4. Select the correct Function to get Minute of the time.

Time: 01:29:35 PM

Result: 29

5. Select the correct Function to get Hour of the time.

Time: 01:29:35 PM

Result:13

6. Select the correct Function to get second of the time.

Time: 01:29:35 PM

Result: 35

7. Select the correct Function using below HOUR, MINUTE, SECOND get the proper time.

Hour: 13

Minute: 29

Second: 35

Result Time: 01:29:35 PM

8. Select the correct Function using below Year, Month, Day to create a proper date.

Year: 2020

Month: 8

Day: 15

Result Date: 15-08-2020

9. Select the correct Function to get only the day of the date.

Date: 15-08-2020

Result: 15

10. Select the correct Function to get the only Month of the date.

Date: 15-08-2020

Result: 8

11. Select the correct Function to get the only year of the date.

Date 15-08-2020

Result: 2020