Date & Time Functions

DATEThe serial number of a date given the year, month, day.
DATEDIF(Compatibility) The number of units between two dates.
DATEVALUEThe serial number that represents a given 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 serial number that is a given 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 in 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 given a date serial number.
TIMEThe time as a decimal given the hour, minute and second.
TIMEVALUEThe time as a decimal returned as text given a date serial number.
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.

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