Explainry Tutorials to Expert in IT

Date functions in Google Sheets

Date function converts a year, month and day into a date. DATEDIF function provides number of days, months or years between two dates. DATEVALUE function converts a date formatted as text or in any other valid format, into a proper Google Sheets date format. DAYS function returns the number of days between two given dates. […]

ISDATE Function in Google Sheets

The ISDATE function checks whether the given date is a valid date format or not. The function returns True if the date is a valid date otherwise False. Syntax ISDATE(value) value – Required. The value you want to test. Examples Related posts: DATEVALUE Function in Google Sheets DATEDIF function in Google Sheets MINUTE function in […]

HOUR function in Google Sheets

The HOUR function returns the hour from a given time as an integer between 0 (12:00 A.M.) – 23 (11:00 P.M.). For example, the formula =HOUR(“12:20:17”) returns 12. Syntax HOUR(time) time – The time value from which the hour to extract. Example For more detail, visit Google official website. Related posts: DAYS360 Function in Google […]

EOMONTH Function in Google Sheets

The EOMONTH function (End of Month) returns the last date of a month after adding specified number of months to a date. For example, the formula =EOMONTH(“12 Dec 2019”,1) returns “31 Jan 2020” which is one month later than the specified date. Syntax EOMONTH(start_date, months) start_date – Required. The start date to use in the […]

EDATE function

The EDATE function returns the date after or before a specified date. For this a number is specified, for example, =EDATE(“12 Dec 2019”,1) returns the 12 Jan 2020 date which is one month after the specified date. The number “1” is used to indicate one month after, use -1 for one month before. The EDATE […]

DAYS360 Function in Google Sheets

In the financial calculations, the DAYS360 function returns number of total days between two dates based on a 360 day year count. Syntax DAYS360(start_date, end_date, [method]) start_date – Required. The start date to use in the calculation. end_date – Required. The end date to use in the calculation. [method] – Optional. An indicator to describe […]

DAYS function in Google Sheets

The DAYS function returns the number of days between two given dates. For examples the formula =days(“2/9/2019″,”10/8/2019”) returns 23 days. Syntax DAYS(end_date,start_date) end_date – Required. The end date. start_date – Required. The start date. Example The below formula shows the difference with two dates within a year. The below formula shows the difference with two […]

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