Explainry Tutorials to Expert in IT

YEARFRAC in Google Sheets

The YEARFRAC function returns a decimal value, representing fractional year between two dates. For example, the formula =YEARFRAC(“Jan 2020″,”Feb 2024”) returns the decimal value “4.083“. Syntax YEARFRAC(start_date, end_date, [day_count_convention]) start_date – Required. The start date to be use in the calculation. end_date – Required. The end date to be use in the calculation. [day_count_convention] – […]

YEAR function in Google Sheets

The YEAR function returns the year (as a 4-digit number) from a given date. For example, the function “=YEAR(“Jan 23 2020″)” returns “2020”. Syntax YEAR(date) date – Required. The date from which to extract the year. Example Related posts: TIME function in Google Sheets TODAY function in Google Sheets NOW function in Google Sheets SECOND […]

WEEKNUM function in Google Sheets

The WEEKNUM function returns the week of the year (ranging from 1 to 54) where the given date falls. For example, the formula =WEEKNUM(“15 Aug 2020”) returns “33”, the 33th week of the year 2020. Syntax WEEKNUM(date, [type]) date – Required. The provided date, against which the WEEKNUM is required. [type] – Optional. (The default […]

WEEKDAY function in Google Sheets

The WEEKDAY function returns the day number of the week ranging from from 1 (Sunday) to 7 (Saturday) of the given date. For example, the function ‘=WEEKDAY(“Jan 20 2020”)‘ has the day number “2“, which means it is Monday on that given date. Syntax WEEKDAY(date, [type]) date – Required. The date against which the day […]

TODAY function in Google Sheets

The TODAY function returns the current date that updates continuously. For example, if today date is Jan 15, 2020, the formula ” =TODAY() ” returns “15/01/2020”. Syntax TODAY() The function has no argument. Examples Using Notes The TODAY function returns only the current date, to get current date and time use the NOW function. The […]

TIMEVALUE function in Google Sheets

The TIMEVALUE function converts a given time string into the serial number representation of time in Google Sheets. For example, the formula =TIMEVALUE(“12:00 PM”) returns “0.50”, the numeric representation of time in Google Sheets. Syntax TIMEVALUE(time_string) time_string – Required. The given value of time to be converted into the serial number representation of Google Sheets’ […]

TIME function in Google Sheets

The TIME function enables you to get the time value from a given hour, minute and second components. For example, the syntax TIME(hour, minute, second) results hour:minute:second. For related time functions, visit this page. Syntax TIME(hour, minute, second) hour – Required. The hour component of the required time value. minute – Required. The minute component […]

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved