Category - Date & Time

List of user defined functions

AGEReturns the age of a person given a birthday.
COUNTNUMBEROFDAYSReturns the number of days in a week, month, year
DATEUNITSReturns the number of units between two dates.
DATEUNITS_DReturns the number of whole days between "start_date" and "end_date".
DATEUNITS_MReturns the number of whole months (or months and days) (or months, weeks and days) between "start_date" and "end_date".
DATEUNITS_YReturns the number of whole years (or years and days) (or years, months and days) between "start_date" and "end_date".
DATEUNITS_MDReturns the number of days between "start_date" and "end_date" (ignoring months and years).
DATEUNITS_YDReturns the number of days between "start_date" and "end_date" (ignoring years).
DATEUNITS_YMReturns the number of months between "start_date" and "end_date" (ignoring days and years).
DATESBEFORE1900Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAYReturns the date given a month, a week number and a day of the week.
FIRSTDATEReturns the first date of the day of a week, month or year.
ISDATEReturns whether a date is the first (or last) of a week, month or year.
ISDATE_FIRSTOFAWEEKReturns whether a date is the first day of the week.
ISDATE_FIRSTOFAMONTHReturns whether a date is the first day of the month.
ISDATE_FIRSTOFAYEARReturns whether a date is the first day of a year.
ISDATE_LASTOFAMONTHReturns whether a date is the last day of the month.
ISDATE_LASTOFAWEEKReturns whether a date is the last day of the week.
ISDATE_LASTOFAYEARReturns whether a date is the last day of the 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.
PREVIOUSWEEKDAYReturns the date of the previous weekday.
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.
COUNTNUMBEROFDAYS
Returns the number of days in a week, month, year
DATEUNITS
Returns the number of units between two dates.
DATEUNITS_D
Returns the number of whole days between "start_date" and "end_date".
DATEUNITS_M
Returns the number of whole months (or months and days) (or months, weeks and days) between "start_date" and "end_date".
DATEUNITS_Y
Returns the number of whole years (or years and days) (or years, months and days) between "start_date" and "end_date".
DATEUNITS_MD
Returns the number of days between "start_date" and "end_date" (ignoring months and years).
DATEUNITS_YD
Returns the number of days between "start_date" and "end_date" (ignoring years).
DATEUNITS_YM
Returns the number of months between "start_date" and "end_date" (ignoring days and years).
DATESBEFORE1900
Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAY
Returns the date given a month, a week number and a day of the week.
FIRSTDATE
Returns the first date of the day of a week, month or year.
ISDATE
Returns whether a date is the first (or last) of a week, month or year.
ISDATE_FIRSTOFAWEEK
Returns whether a date is the first day of the week.
ISDATE_FIRSTOFAMONTH
Returns whether a date is the first day of the month.
ISDATE_FIRSTOFAYEAR
Returns whether a date is the first day of a year.
ISDATE_LASTOFAMONTH
Returns whether a date is the last day of the month.
ISDATE_LASTOFAWEEK
Returns whether a date is the last day of the week.
ISDATE_LASTOFAYEAR
Returns whether a date is the last day of the 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.
PREVIOUSWEEKDAY
Returns the date of the previous weekday.
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.

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