Tag: Date

• constants

  units/date

  Calenders: Gregorian, Julian and Excel

• date

  units/date

  Calculates the serial date from the parameters \b day, \b month and \b year. <span align="right" style="background-color:99FF99"><strong>Excel: DATE</strong></span>

• dateDiff

  units/date

  Computes the number of days between two serial Julian dates <span align="right" style="background-color:99FF99"><strong>Open Office: DATEDIFF</strong></span>

• dateDiff360

  units/date

  Computes the number of days between two serial dates using a 360 day accounting years. \begin{html}<span align="right" style="background-color:99FF99"><strong>Excel: DAYS360</strong></span>\end{html}

• DateString

  units/date

  Unit functions

• DateTime

  units/date

  Unit functions

• dateYMD

  units/date

  Converts a serial Julian date into day, month and year values

• date_str

  units/date

  Returns a date formatted according to a given format string.

• day

  units/date

  Extracts the day from a serial Julian date. <span align="right" style="background-color:99FF99"><strong>Excel: DAY</strong></span>

• dayOfWeek

  units/date

  Computes the day of the week (Sunday through to Monday), for the specified serial Julian date.

• dayOfYear

  units/date

  Computes the Gregorian day of the year from a serial Julian date.

• daysInMonth

  units/date

  Returns the number of days in the month of a Gregorian calendars. <span align="right" style="background-color:9999FF"><strong>Open Office: DAYSINMONTH</strong></span>

• daysInYear

  units/date

  Returns the number of days in the year of a Gregorian calendars. <span align="right" style="background-color:9999FF"><strong>Open Office: DAYSINYEAR</strong></span>

• easterSunday

  units/date

  Calculates the date of Easter Sunday for the given year. <span align="right" style="background-color:9999FF"><strong>Open Office: EASTERSUNDAY</strong></span>

• endOfMonth

  units/date

  Advances a serial date to the last day of the month after adding \a months. <span align="right" style="background-color:99FF99"><strong>Excel: EOMONTH</strong></span>

• excelToJulian

  units/date

  Converts serial Excel date into serial Julian date

• firstMonday

  units/date

  Returns the date in January when the first Monday occurs.

• incMonth

  units/date

  Advances a serial date by a number of \a Months. <span align="right" style="background-color:99FF99"><strong>Excel: EDATE</strong></span>

• isLeapYear

  units/date

  Returns true if the specified \a year is a leap-year in the Gregorian calendar (contains 29days in February). <span align="right" style="background-color:9999FF"><strong>Open Office: ISLEAPYEAR</strong></span>

• julianToExcel

  units/date

  Converts serial Julian date into serial Excel date

• month

  units/date

  Extracts the month from a serial Julian date. <span align="right" style="background-color:99FF99"><strong>Excel: MONTH</strong></span>

• month_str

  units/date

  Returns a string pointer to the month of the year.

• networkDays

  units/date

  Returns the number of working days between the start and end dates, excluding holidays. <span align="right" style="background-color:99FF99"><strong>Excel: NETWORKDAYS</strong></span>

• nextWeekDay

  units/date

  Advances the specified date to the next weekday.

• nthWeekDay

  units/date

  Returns the date of the nth weekday within the specified month and year.

• today

  units/date

  Returns the current date as a serial Julian date. <span align="right" style="background-color:99FF99"><strong>Excel: TODAY</strong></span>

• weekday_str

  units/date

  Returns a string for the weekday specified.

• weekOfYear

  units/date

  Computes the week number of a date - ISO, Excel and Simple standards implemented. \begin{html}<span align="right" style="background-color:99FF99"><strong>Excel: WEEKNUM</strong></span>\end{html}

• workDay

  units/date

  Computes the working date from the specified date plus or minus \a days - excluding holidays. <span align="right" style="background-color:99FF99"><strong>Excel: WORKDAY</strong></span>

• year

  units/date

  Extracts the year from a serial Julian date. <span align="right" style="background-color:99FF99"><strong>Excel: MONTH</strong></span>