Question

Answer 9.......

Thanks in advance! ​

Answer 1

Answer : Option(D)

What is YEARFRAC();

It returns the number of years between two dates as a decimal result.

Syntax:

YEARFRAC(start_date,end_date,[basis])

start_date = represents the start of the date.

end_date = represents the end of the date.

basis(Optional) = determines the number of days in the year.

Basis 1 - Actual days in the month/Actual days in the year.

Basis 2 - Actual days/360

Today() - It is used to return the today's date.

Int()** - It output the age value as an integer. If you want decimal value, Just remove the Int() part of the function

Example:

     A

1    6/10/1990

(i) =INT(YEARFRAC(TODAY(),A1))

Here, the int function rounds down that number to the integer value

Output: 28

(ii) =INT(YEARFRAC(TODAY(),A1,2))

    =INT(10548/360)

    =INT(29.3)

Here, the int function rounds down that number to the integer value.

Output: 29

(iii) =INT(YEARFRAC(NOW(),A1,2))

It returns the current date and time. which is considered as end_date.

Output: 29

(iv) =INT(YEARFRAC(DAY(),A1,1))

It returns the day of the month as the number.

Output: 6

Hope this information helps!

Answer 2

Hey!!

Here is your answer -

=INT(YEARFRAC(DAY(), A1, 1))