Category - Date & Time

List of user defined functions

AGEReturns the age of a person given a birthday.
CONVERTTIMEReturns the time converted to a decimal hours, minutes or seconds,
DATESBEFORE1900Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATESERIALReturns the date serial number given a date in text format.
DATEDIFFERENCEReturns the number of days, months or years between two dates.
DATEDIFFERENCE_DReturns the number of whole days between "start_date" and "end_date".
DATEDIFFERENCES_MReturns the number of whole months (or months and days) (or months, weeks and days) between "start_date" and "end_date".
DATEDIFFERENCE_YReturns the number of whole years (or years and days) (or years, months and days) between "start_date" and "end_date".
DATEDIFFERENCE_MDReturns the number of days between "start_date" and "end_date" (ignoring months and years).
DATEDIFFERENCE_YDReturns the number of days between "start_date" and "end_date" (ignoring years).
DATEDIFFERENCE_YMReturns the number of months between "start_date" and "end_date" (ignoring days and years).
DATEWHICHDAYReturns the date given a month, a week number and a day of the week.
DAYSTOReturns the number of days (or other units) to a specific event.
DAYSTOCHRISTMASReturns the number of days to Christmas.
FIRSTDATEReturns the first date of the day of a week, month or year.
ISDATEReturns whether a particular value is a valid date.
ISDATEFIRSTReturns whether a date is the first of a week, month or year.
ISDATELASTReturns whether a date is the last of a week, month or year.
LASTDATEReturns the date of the last day of a week, month or year.
NETWORKDAYSMISCReturns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAYReturns the date of the next weekday.
NUMBEROFDAYSReturns the number of days in a month and/or year.
PREVIOUSWEEKDAYReturns the date of the previous weekday.
TIMENOWReturns the current time as a string (in the format "hh:mm:ss").
WEEKNUMBERReturns the week number of a particular date.
WORKDAY6Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISCReturns the serial number before or after a given number of days from a start date using a defined list of workdays.
AGE
Returns the age of a person given a birthday.
CONVERTTIME
Returns the time converted to a decimal hours, minutes or seconds,
DATESBEFORE1900
Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATESERIAL
Returns the date serial number given a date in text format.
DATEDIFFERENCE
Returns the number of days, months or years between two dates.
DATEDIFFERENCE_D
Returns the number of whole days between "start_date" and "end_date".
DATEDIFFERENCES_M
Returns the number of whole months (or months and days) (or months, weeks and days) between "start_date" and "end_date".
DATEDIFFERENCE_Y
Returns the number of whole years (or years and days) (or years, months and days) between "start_date" and "end_date".
DATEDIFFERENCE_MD
Returns the number of days between "start_date" and "end_date" (ignoring months and years).
DATEDIFFERENCE_YD
Returns the number of days between "start_date" and "end_date" (ignoring years).
DATEDIFFERENCE_YM
Returns the number of months between "start_date" and "end_date" (ignoring days and years).
DATEWHICHDAY
Returns the date given a month, a week number and a day of the week.
DAYSTO
Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS
Returns the number of days to Christmas.
FIRSTDATE
Returns the first date of the day of a week, month or year.
ISDATE
Returns whether a particular value is a valid date.
ISDATEFIRST
Returns whether a date is the first of a week, month or year.
ISDATELAST
Returns whether a date is the last of a week, month or year.
LASTDATE
Returns the date of the last day of a week, month or year.
NETWORKDAYSMISC
Returns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAY
Returns the date of the next weekday.
NUMBEROFDAYS
Returns the number of days in a month and/or year.
PREVIOUSWEEKDAY
Returns the date of the previous weekday.
TIMENOW
Returns the current time as a string (in the format "hh:mm:ss").
WEEKNUMBER
Returns the week number of a particular date.
WORKDAY6
Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISC
Returns the serial number before or after a given number of days from a start date using a defined list of workdays.

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