Skip to content
Sheet Natives
  • Home
  • Top Rated Google Sheets Courses [Updated 2020]
  • Sheets Templates
  • About

How to Use YEAR in Google Sheets in 2020?

July 29, 2020July 19, 2020 by Ali
YEAR

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 …

Read moreHow to Use YEAR in Google Sheets in 2020?

How to Use TRUE in Google Sheets in 2020?

July 19, 2020July 19, 2020 by Ali
TRUE Function in Google Sheets

Returns the logical value `TRUE`. Sample Usage =TRUE() Syntax TRUE() Notes In most cases, Google Sheets will automatically convert the …

Read moreHow to Use TRUE in Google Sheets in 2020?

How to Use XOR function in Google Sheets in 2020?

July 15, 2020July 15, 2020 by Ali
XOR Function

The XOR function returns TRUE if an odd number of the provided arguments are logically true, and FALSE otherwise. Parts …

Read moreHow to Use XOR function in Google Sheets in 2020?

How to Use YIELDMAT function in Google Sheets in 2020?

July 14, 2020July 7, 2020 by Ali

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?

July 14, 2020July 7, 2020 by Ali

YIELDCalculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Sample …

Read moreHow to Use YIELD in Google Sheets in 2020?

How to Use YEARFRAC in Google Sheets in 2020?

July 14, 2020July 7, 2020 by Ali

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

Read moreHow to Use YEARFRAC in Google Sheets in 2020?

How to Use WORKDAY.INTL in Google Sheets in 2020?

July 15, 2020July 7, 2020 by Ali
WORKDAY.INT

WORKDAY.INTL Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Sample Usage WORKDAY.INTL(DATE(1969, 7, …

Read moreHow to Use WORKDAY.INTL in Google Sheets in 2020?

How to Use WORKDAY in Google Sheets in 2020?

July 14, 2020July 7, 2020 by Ali

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, …

Read moreHow to Use WORKDAY in Google Sheets in 2020?

How to Use WEIBULL in Google Sheets in 2020?

July 14, 2020July 7, 2020 by Ali

WEIBULLReturns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. Sample …

Read moreHow to Use WEIBULL in Google Sheets in 2020?

How to Use WEEKNUM in Google Sheets in 2020?

July 14, 2020July 7, 2020 by Ali

WEEKNUMReturns a number representing the week of the year where the provided date falls. Sample Usage WEEKNUM(DATE(1969, 7, 20), 1) …

Read moreHow to Use WEEKNUM in Google Sheets in 2020?

Post navigation
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 … Page47 Next →

Recent Posts

  • How to Use AND function in Google Sheets?
  • IFERRORIFERROR in Google Sheets; How to use it?
  • ISDATEHow to Use ISDATE function in Google Sheets
  • quotientHow to Use QUOTIENT function in Google Sheets?
  • How to Use NORMINV in Google Sheets?
  • Impressum
  • Sitemap
  • Privacy Policy
© 2022 Sheet Natives • Built with GeneratePress
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT