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 …
How to Use TRUE in Google Sheets in 2020?
Returns the logical value `TRUE`. Sample Usage =TRUE() Syntax TRUE() Notes In most cases, Google Sheets will automatically convert the …
How to Use XOR function in Google Sheets in 2020?
The XOR function returns TRUE if an odd number of the provided arguments are logically true, and FALSE otherwise. Parts …
How to Use YIELDMAT function in Google Sheets in 2020?
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?
How to Use YIELD 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 …
How to Use YEARFRAC in Google Sheets in 2020?
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) …
How to Use WORKDAY.INTL in Google Sheets in 2020?
WORKDAY.INTL Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Sample Usage WORKDAY.INTL(DATE(1969, 7, …
How to Use WORKDAY in Google Sheets in 2020?
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, …
How to Use WEIBULL in Google Sheets in 2020?
WEIBULLReturns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Sample …
How to Use WEEKNUM in Google Sheets in 2020?
WEEKNUMReturns a number representing the week of the year where the provided date falls. Sample Usage WEEKNUM(DATE(1969, 7, 20), 1) …