Tag: Units

• angle

  units/convert

  Angle Units, including imperial and SI units

• area

  units/convert

  Measurement units, including imperial and SI units

• constants

  units/date

  Calenders: Gregorian, Julian and Excel

• Conversion Factors

  units/convert

  A list of the most common conversion factors from the Imperial the MKS system of measurements

• convert

  units/convert

  Converts any numbers from one unit to another

• 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>

• density

  units/convert

  Density units, including imperial and SI units

• Dimensional Analysis

  units

  Describes dimensional analysis and explains a method for converting physical units

• distance

  units/convert

  Distance units, including imperial and SI units

• 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.

• flow

  units/convert

  Measurement units, including imperial and SI units

• force

  units/convert

  Force units, including imperial and SI units

• GMTOffset

  units/time

  Calculates the number of minutes that the given region is offset from GMT

• hour

  units/time

  Returns the current hour from a serial Julian date and time. <span align="right" style="background-color:99FF99"><strong>Excel: HOUR</strong></span>

• 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>