Date & Time Functions

List of user defined functions

AGEReturns the age of a person given a birthday.
COUNTNUMBEROFDAYSReturns the number of days in a week, month, year
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.
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
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.
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