DateTime
WORKDAY.INTL
Returns the end date away from a given number of working days. It allows customized weekend days for the calculation. Syntax WORKDAY.INTL(start_date; days; [weekend]; [hol_range]) start_date: The starting date for the calculation. E.g. "1/17/20" ...YEARS
Returns the number of years between two given dates. Syntax YEARS(start_date; end_date; [mode]) start_date: The date from which to calculate the number of years. E.g. "2/5/2020" end_date: The date up to which to calculate the number of years. ...YEARFRAC
Returns the number of years, including fractional years, between two given dates. Syntax YEARFRAC(start_date; end_date; [basis]) start_date: The date from which to calculate the number of years. E.g. "2/5/2020" end_date: The date up to which to ...YEAR
Returns the year of a given date. Syntax YEAR(date) date: The date that you want the year of. E.g. "2/13/00" Examples Formula Result =YEAR("2/13/00") 2000 =YEAR("3 August") 2020 =YEAR(F2&"/"&E2&"/"&G2) 1999 Get a hands-on experience of the ...WORKDAY
Returns the end date away from a given number of working days. Syntax WORKDAY(start_date; days; [hol_range]) start_date: The starting date for the calculation. E.g. "1/17/20" days: The number of working days to count from the start_date. Counts ...WEEKSINYEAR
Returns the number of weeks in a given year. Syntax WEEKSINYEAR(date) date: The date containing the year that you want to find the number of weeks of. E.g. "3 Aug, 2020" Examples Formula Result =WEEKSINYEAR("3 Aug, 2020") 53 ...WEEKS
Returns the number of weeks between two given dates. Syntax WEEKS(start_date; end_date; [mode]) start_date: The date from which to calculate the number of weeks. E.g. "2/5/2020" end_date: The date up to which to calculate the number of weeks. ...WEEKNUM_ADD
Returns the non-ISO week number of a given date. Syntax WEEKNUM_ADD(date; [mode]) date: The date for which you want to find the week number. E.g. "2/3/2020" mode: Determines the numbering system to use. Defaults to 1 if omitted. mode Week ...WEEKNUM
Returns the number representing the week of the year for a given date. Syntax WEEKNUM(date; [mode]) date: The date for which you want to find the week number. E.g. "2/3/2020" mode: Determines the numbering system to use. Defaults to 1 if omitted. ...WEEKDAY
Returns the number representing the day of the week for a given date. Syntax WEEKDAY(date; [type]) date: The date for which you want to find the day of the week. E.g. "3/4/2020" type: Determines the numbering system to use. Defaults to 1 if ...TODAY
Returns the current date. Syntax TODAY() Remarks The date value changes to the current date on every recalculation of the function. Examples Formula Result =TODAY() 9/11/20 Possible Errors Errors Meaning #N/A! The function could not find ...TIMEVALUE
Returns the decimal number from a time given as text. Syntax TIMEVALUE(time_text) time_text: A time expressed in the form of text. E.g. "14:30PM" Remarks The result ranges from 0 to 0.99988426, indicating the time from 12:00:00 AM to 11:59:59 ...TIME
Returns the time, given the hours, minutes, and seconds. Syntax TIME(hours; minutes; seconds) hours: The hour component of the time. E.g. 2 minutes: The minute component of the time. E.g. 30 second: The second component of the time. E.g. 50 ...SECOND
Returns the seconds of a given time as a number between 0-59. Syntax SECOND(time) time: The time you want the second value of. E.g. "12:30:53" Remarks Date formats without the time specified will have the time considered as 00:00:00. Examples ...NOW
Returns the current date and time. Syntax NOW() Remarks The time value changes to the current time on every recalculation of the function. Examples Formula Result NOW() 09/11/20 09:15:00 AM Possible Errors Errors Meaning #N/A! The ...NETWORKDAYS.INTL
Returns the number of working days between two given dates, inclusive. It allows customized weekend days for the calculation. Syntax NETWROKDAYS.INTL(start_date; end_date; [weekend]; [hol_range]) start_date: Date from which the calculation ...NETWORKDAYS
Returns the number of working days between two given dates, inclusive. Syntax NETWORKDAYS(start_date; end_date; [hol_range]) start_date: Date from which the calculation starts. E.g. "1/1/2020" end_date: Date on which the calculation ends. E.g. ...MONTHS
Returns the number of months between two given dates. Syntax MONTHS(start_date; end_date; [mode]) start_date: The date from which to calculate the number of months. E.g. "2/5/2020" end_date: The date up to which to calculate the number of months. ...MONTH
Returns the month of a given date as an integer. Syntax MONTH(date) date: The date that you want to find the month of. Can be a text or date-time serial number. E.g. "2/13/2020" Examples Formula Result =MONTH("2/13/2020") 2 =MONTH("3 August, ...MINUTE
Returns the minutes of a given time as a number between 0 and 59. Syntax MINUTE(time) time: The time whose minute value you want. E.g. "12:30:00" Remarks Date formats without the time specified will have the time considered as 00:00:00. ...ISLEAPYEAR
Returns 1 if the given date lies in a leap year, and 0 otherwise. Syntax ISLEAPYEAR(date) date: The date given to test. E.g. "12/2/2020" Examples Formula Result =ISLEAPYEAR("12/2/2020") 1 =ISLEAPYEAR("1/1/2019") 0 =ISLEAPYEAR(TODAY()) 1 Get a ...HOUR
Returns the hour of given time as a number. Its value lies between 0 - 23. Syntax HOUR(time) time: A text or date-time serial number. E.g. "12:30:00" Remarks Date formats without the time specified will have the time considered as 00:00:00. ...EOMONTH
Returns the last date of a month, given a number of months before or away from the start date in date serial number. Syntax EOMONTH(start_date; months) start_date: The date to which you want to add/remove the given number of months. E.g. "1/1/2020" ...EDATE
Returns the date-serial number that is the given number of months away or before the specified date. The day of the month remains unchanged, unless it is more than the number of days in the new month. Syntax EDATE(start_date; months) start_date: ...EASTERSUNDAY
Returns the date of Easter Sunday in a given year. Syntax EASTERSUNDAY(year) year: An integer between 1583 and 9956 or between 0 and 99, specifying the year. E.g. 2020 Examples Formula Result =EASTERSUNDAY(2020) 4/12/20 =EASTERSUNDAY(21) ...DAYSINYEAR
Returns the number of days in the year specified in the given date. Syntax DAYSINYEAR(date) date: The date used as input. E.g. "3 Aug, 2020" Examples Formula Result =DAYSINYEAR("3 Aug, 2020") 366 =DAYSINYEAR("2/1/2019") 365 =DAYSINYEAR(2001) ...DAYSINMONTH
Returns the number of days in the month specified in the given date. Syntax DAYSINMONTH(date) date: The date used as input. E.g. "3 Aug, 2020" Remarks Alternatively, =DAY(EOMONTH("2/1/2019";0)) can also be used to get the number of days in a ...DAYS360
Returns the number of days between two dates using the 360-day year, which includes twelve 30-day months. Syntax DAYS360(start_date; end_date; [method]) start_date: The date from which you want to calculate the number of days. E.g. "2/5/2020" ...DAYS
Returns the number of days between two given dates i.e. end_date - start_date. Syntax DAYS(end_date; start_date) end_date: The date till which you want to calculate the number of days. E.g. "7/8/2020" start_date: The date from which you want to ...DAY
Returns the day of a given date as a number from 1 to 31. Syntax DAY(date) date: The date whose day value you want to display. E.g. "2/13/2020" Examples Formula Result =DAY("2/13/2020") 13 =DAY("3 August, 2020") 3 =DAY(F2&"/"&E2&"/"&G2) 2 Get ...DATEVALUE
Returns the date-time serial number, from a date given as text. This can be formatted to read as a date. Syntax DATEVALUE(date_text) date_text: A date expressed in the form of text. E.g. "2/13/2020" Examples Formula Result ...DATEDIF
Returns the number of days, months, or years between two given dates. Syntax DATEDIF(start_date; end_date; type) start_date: Starting date for the period. E.g. "1/1/2020" end_date: Final or end date for the specified period. E.g. "2/4/2018" type: ...DATE
Returns the date, given the year, month, and day of the month. Syntax DATE(year; month; day) year: The year to display in the result. Must be an integer between 1583 and 9956, or between 0 and 99. E.g. 2020 month: The month to display in the ...
Access your files securely from anywhere
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?