Free Excel Quiz to Test your knowledge This quiz will improve your Knowledge in Excel Date and Time Functions Please enter your email: 1. How to get the 01-Jan-2021 using EOMONTH function if the start date is 25-Dec-2020? =EOMONTH(Start Date,0)+2 =EOMONTH(Start Date,-1) =EOMONTH(Start Date,0)+1 =EOMONTH(Start Date,1)+1 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. NETWORKDAYS NETWORKDAYS.INTL DAYS DAYS360 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 EDATE(Start Date,12)+15 EDATE(Start Date,06)-5 EDATE(Start Date,05)+5 EDATE(Start Date,12)+5 4. Select the correct Function to get Minute of the time. Time: 01:29:35 PM Result: 29 DAY MINUTE TIME SECOND 5. Select the correct Function to get Hour of the time. Time: 01:29:35 PM Result:13 HOUR MINUTE SECOND TIME 6. Select the correct Function to get second of the time. Time: 01:29:35 PM Result: 35 HOUR TIME SECOND MINUTE 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 HOUR TIME SECOND MINUTE 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 DAYS360 DAY DATE DAYS 9. Select the correct Function to get only the day of the date. Date: 15-08-2020 Result: 15 DATE MONTH DAYS DAY 10. Select the correct Function to get the only Month of the date. Date: 15-08-2020 Result: 8 DATE YEAR MONTH DAY 11. Select the correct Function to get the only year of the date. Date 15-08-2020 Result: 2020 DATE YEAR MONTH DAY Loading … 000000 Post navigation Excel VBA Quiz