Date & Time Functions

DATEThe date as a date serial number given a year, month, day.
DATEDIF(Compatibility) The number of days, months or years 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 date 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.INTLThe total number of working days between two dates excluding weekends and holidays.
NOWThe date 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 the hour, minute and second.
TIMEVALUEThe time as a decimal given a time in text format.
TODAYThe date 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 date serial number that is a given number of working days before or after a date.
WORKDAY.INTL(2010) The date 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.

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