• # DateTime

• ## 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. ...

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 date of the last day given number of months away or before the specified date in the form of a date serial number.   Syntax   EOMONTH(start_date; months) start_date: The date to which you want to add/remove the given number of months. ...
• ## 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 ...