Date and Time | MCQs

Explanation

The DATEDIF() function is used to get days, months, or years between two dates.

Syntax: =DATEDIF (start_date, end_date, unit).

Additional information:

 DATEDIFF()

The DATEDIFF() function returns the difference between two dates.

Syntax. DATEDIFF(interval, date1, date2).

*

DAYSBETWEEN

The daysBetween function takes startDateValue and endDateValue 

Syntax. daysBetween( date1 , date2 ).

Explanation

Date and Time' located in the taskbar

Explanation

Shift + Alt + D = Insert the current date.

This shortcut is commonly used in Microsoft Word to quickly add the current date to a document.