YEAR

Returns the year as a number according to the internal calculation rules.

SIGN (සංඛ්‍යාව)

Number shows the internal date value for which the year is to be returned.

=ODD(1) 1 ආපසු එවයි.

=SIGN(3.4) returns 1.