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.

DAYS360 function returns number of total days between two dates based on a 360 day year count.

EDATE function returns the date after or before a specified date.

EOMONTH function (End of Month) returns the last date of a month after adding specified number of months to a date.

HOUR function returns the hour from a given time as an integer between 0 (12:00 A.M.) – 23 (11:00 P.M.).

ISDATE function checks whether the given date is a valid date format or not.

ISOWEEKNUM returns the number of ISO week of the year if a date is provided.

MINUTE function returns an integer value (in minutes) ranging from 1 to 59 from a given time value.

MONTH function returns the month number ranging from 1 (Jan) to 12 (Dec).

NETWORKDAYS function returns the net working days between two given dates after excluding weekends (Saturday and Sunday) automatically.

NETWORKDAYS.INTL function calculates the networking days between two given dates after excluding specified weekends and holidays.

NOW function returns the current date and time, updates continuously whenever you open the worksheet.

SECOND function returns the second component from a given time value, in numeric format ranging from 0 to 59.

TIME function enables you to get the time value from a given hour, minute and second components.

TIMEVALUE function converts a given time string into the serial number representation of time in Google Sheets.

TODAY function returns the current date that updates continuously.

WEEKDAY function returns the day number of the week ranging from from 1 (Sunday) to 7 (Saturday) of the given date.




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