## 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 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) …