Date & Time Functions

DATEThe date as a date serial number given a year, month, day.
DATEDIFThe number of units between two dates.
DATEVALUEThe date serial number given a date in text format.
DAYThe day as an integer given a date serial number.
DAYS(2013) The number of days between two dates.
DAYS360The number of days between two dates, based on 30 day months.
EDATEThe date serial number that is a certain number of months before or after a date.
EOMONTHThe serial number of the last day of a month before or after a date.
HOURThe hour as an integer given a date serial number.
ISOWEEKNUM(2013) The number of the ISO week of the year for a given date.
MINUTEThe minute as an integer given a date serial number.
MONTHThe month as an integer given a date serial number.
NETWORKDAYS(NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays.
NETWORKDAYS.INTL(2010) The total number of working days between two dates excluding weekends and holidays.
NOWThe serial number of the current system date and time.
SECONDThe number of seconds as an integer given a date serial number.
TIMEThe time as a decimal given an hour, minute, second.
TIMEVALUEThe time as a decimal given a time in text format.
TODAYThe serial number representing today's date.
WEEKDAYThe day of the week for a given date.
WEEKNUMThe week number in the year for a given date.
WORKDAY(WORKDAY.INTL) The serial number that is a given number of working days before or after a date.
WORKDAY.INTL(2010) The serial number that is a given number of working days before or after a date.
YEARThe year as an integer given a date serial number.
YEARFRACThe number of years as a decimal between two dates.
DATE
The date as a date serial number given a year, month, day.
DATEDIF
The number of units between two dates.
DATEVALUE
The date serial number given a date in text format.
DAY
The day as an integer given a date serial number.
DAYS
(2013) The number of days between two dates.
DAYS360
The number of days between two dates, based on 30 day months.
EDATE
The date serial number that is a certain number of months before or after a date.
EOMONTH
The serial number of the last day of a month before or after a date.
HOUR
The hour as an integer given a date serial number.
ISOWEEKNUM
(2013) The number of the ISO week of the year for a given date.
MINUTE
The minute as an integer given a date serial number.
MONTH
The month as an integer given a date serial number.
NETWORKDAYS
(NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays.
NETWORKDAYS.INTL
(2010) The total number of working days between two dates excluding weekends and holidays.
NOW
The serial number of the current system date and time.
SECOND
The number of seconds as an integer given a date serial number.
TIME
The time as a decimal given an hour, minute, second.
TIMEVALUE
The time as a decimal given a time in text format.
TODAY
The serial number representing today's date.
WEEKDAY
The day of the week for a given date.
WEEKNUM
The week number in the year for a given date.
WORKDAY
(WORKDAY.INTL) The serial number that is a given number of working days before or after a date.
WORKDAY.INTL
(2010) The serial number that is a given number of working days before or after a date.
YEAR
The year as an integer given a date serial number.
YEARFRAC
The number of years as a decimal between two dates.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top