SpreadJS 14
Formula Reference / Formula Functions / Date and Time Functions
In This Topic
    Date and Time Functions
    In This Topic

    Spread provides the following date and time functions, listed alphabetically.

    Function Description
    DATE This function returns the DateTime object for a particular date, specified by the year, month, and day.
    DATEDIF This function returns the number of days, months, or years between two dates.
    DATEVALUE This function returns a DateTime object of the specified date.
    DAY This function returns the day number of the month (integer 1 to 31) that corresponds to the specified date.
    DAYS This function returns the number of days between two dates.
    DAYS360 This function returns the number of days between two dates based on a 360-day year.
    EDATE This function calculates the date that is the indicated number of months before or after a specified date.
    EOMONTH This function calculates the date for the last day of the month (end of month) that is the indicated number of months before or after the starting date.
    HOUR This function returns the hour that corresponds to a specified time.
    ISOWEEKNUM This function returns the number of the ISO week number of the year for a given date.
    MINUTE This function returns the minute corresponding to a specified time.
    MONTH This function returns the month corresponding to the specified date value.
    NETWORKDAYS This function returns the total number of complete working days between the start and end dates.
    NETWORKDAYS.INTL This function returns the number of workdays between two dates using arguments to indicate holidays and weekend days.
    NOW This function returns the current date and time.
    SECOND This function returns the seconds (0 to 59) value for a specified time.
    TIME This function returns the TimeSpan object for a specified time.
    TIMEVALUE This function returns the TimeSpan object of the time represented by a text string.
    TODAY This function returns the date and time of the current date.
    WEEKDAY This function returns the number corresponding to the day of the week for a specified date.
    WEEKNUM This function returns a number that indicates the week of the year numerically.
    WORKDAY This function returns the number of working days before or after the starting date.
    WORKDAY.INTL This function returns the serial number of the date before or after a number of workdays with custom weekend parameters. These parameters indicate weekend days and holidays.
    YEAR This function returns the year as an integer for a specified date.
    YEARFRAC This function returns the fraction of the year represented by the number of whole days between the start and end dates.