Date & Time Functions

Clarkson ITT Wiki functions logoThis section of the Clarkson ITT Wiki includes articles and videos tagged as providing technical information on or demonstrating the use of the functions for working with and calculating Serial Date and Serial Time values.  This includes deriving information about a date or time.

Some articles are tagged as being available only to students and alumni of specific courses, or for subscribers to the The Learning HabITT and only those to which you have access will be listed.  You may need to login to see all the articles available to you.

Title Modified Date
DATE 10 July 2022
DATEVALUE 10 July 2022
DAY, MONTH, YEAR 11 July 2022
EDATE 11 July 2022
EOMONTH 19 March 2024
HOUR, MINUTE, SECOND 11 July 2022
ISOWEEKNUM 10 July 2022
NETWORKDAYS.INTL, NETWORKDAYS 11 July 2022
NOW 10 July 2022
TIME 07 July 2022
TIMEVALUE 10 July 2022
TODAY 10 July 2022
WEEKDAY 11 July 2022
WEEKNUM 11 July 2022
WORKDAY.INTL, WORKDAY 11 July 2022
YEARFRAC 12 July 2022
λEasterOrthodox 15 October 2025
λEasterWestern 15 October 2025
λFinancialHalf 16 October 2025
λFinancialHalfEnd 16 October 2025
λFinancialQuarter 16 October 2025
λFinancialQuarterEnd 16 October 2025
λFinancialYear 16 October 2025
λFinancialYearEnd 16 October 2025