Date functions

Date functions calculate dates and manipulate date information.

System formats affect the way dates are displayed. See Opening files with different system formats.

Function

Purpose

Date

Returns the calendar date for a month, day, and year.

Day

Returns a number from 1 to 31, for the day of the month on which a date occurs.

DayName

Returns text that is the full name of the weekday for a date.

DayOfWeek

Returns a number representing the day of the week on which a date occurs.

DayOfYear

Returns the number of days from the beginning of the year of a date.

Month

Returns a number from 1 to 12, representing the month of the year in which a date occurs.

MonthName

Returns the full name of the month for a date.

WeekOfYear

Returns the number of weeks after January 1 of the year of a date.

WeekOfYearFiscal

Returns a number from 1 to 53, representing the week containing a date, from a starting day.

Year

Returns a number representing the year in which a date occurs.

Notes 

  • You can use zero (0) and negative numbers as date function arguments. For example, the following formula returns 5/31/2019:
  • Copy
    Date ( 6 ; 0 ; 2019 )