Answer 9.......
Thanks in advance!
Answers
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!
INT(YEARFRAC(TODAY(),A1,2))
=INT(10548/360)
which returns 10548. So, INT(10548/360)
Hey!!
Here is your answer -
=INT(YEARFRAC(DAY(), A1, 1))