Category - Date & Time

List of user defined functions

AGE	Returns the age of a person given a birthday.
BUSDAYDIFF	Returns the number of business days between two dates.
BUSDAYMONTHEND	Returns the last business day in a particular month and year.
BUSDAYMONTHSTART	Returns the first business day in a particular month and year.
BUSDAYNEXT	Returns the next business day if the given date is not a business day.
BUSDAYNTH	Returns the nth business day in a particular month and year.
BUSDAYPREVIOUS	Returns the previous business day if the given date is not a business day.
BUSDAYSADD	Returns the date after adding or removing a number of business days to or from a date.
BUSDAYYEAREND	Returns the last business day in a particular year.
BUSDAYYEARSTART	Returns the first business day in a particular year.
CONVERTTIME	Returns the time converted to a decimal, given hours, minutes or seconds.
DATEADDTENOR	Returns the date after adding or removing a tenor.
DATEADDYMD	Returns the date after adding or removing a given number of years, months and days.
DATECOUNTFRACTION	Returns the date count fraction between two dates.
DATEDIFFERENCE	(Replaces DATEDIF) Returns the number of days, months or years between two dates.
DATEFIRST	Returns the first date of the day of a week, month or year.
DATEFREQUENCYTOTENOR	Returns the tenor based on the frequency.
DATEHOLIDAYSGET	Returns the list of holidays between two dates.
DATELAST	Returns the date of the last day of a week, month or year.
DATENEXTIMM	Returns the International Money Market date based on a range.
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.
DATEWHICHDAY	Returns the date given a month, a week number and a day of the week.
DAYSACCRUAL	Returns the number of accrual days between two dates with a given basis.
DAYSINAMONTH	Returns the number of days in a particular month and year.
DAYSINAYEAR	Returns the number of days in a particular year.
DAYSTO	Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS	Returns the number of days to the next Christmas.
ISDATEVALID	Returns whether a particular value is a valid date.
ISDATEBUSDAY	Returns whether a particular value is a valid business day.
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.
NETWORKDAYSMISC	Returns the number of days between two dates using a defined list of workdays.
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.

AGE Returns the age of a person given a birthday.
BUSDAYDIFF Returns the number of business days between two dates.
BUSDAYMONTHEND Returns the last business day in a particular month and year.
BUSDAYMONTHSTART Returns the first business day in a particular month and year.
BUSDAYNEXT Returns the next business day if the given date is not a business day.
BUSDAYNTH Returns the nth business day in a particular month and year.
BUSDAYPREVIOUS Returns the previous business day if the given date is not a business day.
BUSDAYSADD Returns the date after adding or removing a number of business days to or from a date.
BUSDAYYEAREND Returns the last business day in a particular year.
BUSDAYYEARSTART Returns the first business day in a particular year.
CONVERTTIME Returns the time converted to a decimal, given hours, minutes or seconds.
DATEADDTENOR Returns the date after adding or removing a tenor.
DATEADDYMD Returns the date after adding or removing a given number of years, months and days.
DATECOUNTFRACTION Returns the date count fraction between two dates.
DATEDIFFERENCE (Replaces DATEDIF) Returns the number of days, months or years between two dates.
DATEFIRST Returns the first date of the day of a week, month or year.
DATEFREQUENCYTOTENOR Returns the tenor based on the frequency.
DATEHOLIDAYSGET Returns the list of holidays between two dates.
DATELAST Returns the date of the last day of a week, month or year.
DATENEXTIMM Returns the International Money Market date based on a range.
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.
DATEWHICHDAY Returns the date given a month, a week number and a day of the week.
DAYSACCRUAL Returns the number of accrual days between two dates with a given basis.
DAYSINAMONTH Returns the number of days in a particular month and year.
DAYSINAYEAR Returns the number of days in a particular year.
DAYSTO Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS Returns the number of days to the next Christmas.
ISDATEVALID Returns whether a particular value is a valid date.
ISDATEBUSDAY Returns whether a particular value is a valid business day.
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.
NETWORKDAYSMISC Returns the number of days between two dates using a defined list of workdays.
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.