Question

2. Write the syntax for DATEDIF function.​

Answer 1

The DATEDIF function has three arguments.

• Fill in "d" for the third argument to get the number of days between two dates. ...

Fill in "d" for the third argument to get the number of days between two dates. ...• Fill in "m" for the third argument to get the number of months between two dates.

Fill in "d" for the third argument to get the number of days between two dates. ...• Fill in "m" for the third argument to get the number of months between two dates.• Fill in "y" for the third argument to get the number of years between two dates.

Answer 2

The DATE function creates a valid date using three arguments: year, month, and day: =DATE(year,month,day) In cell C6, we use the LEFT, MID, and RIGHT functions to extract each of these components from a text string... The COUNTIFS function is built to count cells that meet multiple criteria.