How to Use YEAR in Google Sheets in 2020?
Returns the year specified by a given date. Sample Usage =YEAR(DATE(1969,7,20)) =YEAR(A2) =YEAR(40909) Syntax YEAR(date) date – The date from …
Returns the year specified by a given date. Sample Usage =YEAR(DATE(1969,7,20)) =YEAR(A2) =YEAR(40909) Syntax YEAR(date) date – The date from …
Returns the logical value `TRUE`. Sample Usage =TRUE() Syntax TRUE() Notes In most cases, Google Sheets will automatically convert the …
The XOR function returns TRUE if an odd number of the provided arguments are logically true, and FALSE otherwise. Parts …
YIELDMAT functionThe YIELDMAT function calculates the annual yield of a security paying interest at maturity, based on price. Parts of …
Read moreHow to Use YIELDMAT function in Google Sheets in 2020?
YIELDCalculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Sample …
YEARFRACReturns the number of years, including fractional years, between two dates using a specified day count convention. Sample Usage YEARFRAC(DATE(1969,7,16),DATE(1969,7,24),1) …
WORKDAY.INTL Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Sample Usage WORKDAY.INTL(DATE(1969, 7, …
WORKDAYCalculates the end date after a specified number of working days. Sample Usage WORKDAY(DATE(1969,7,20), 4, A1:A10) WORKDAY(A2, 10) WORKDAY(40909, 4, …
WEIBULLReturns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Sample …
WEEKNUMReturns a number representing the week of the year where the provided date falls. Sample Usage WEEKNUM(DATE(1969, 7, 20), 1) …