Functions:


@AGEDATEconverts an NTFS file age into a date and time
@CENTURYreturns the century number for a date or for a year
@DATEconverts a date into a day number
@DATECONVconverts a date from one format into another
@DATEPLUSadds a number of days to a date
@DAYreturns the day of the month for a date
@DAYSreturns the difference in days between two dates
@DECTOTIMEconverts a decimal day fraction to hours, minutes, and seconds
@DOWreturns the abbreviated name of the day of the week for a date
@DOWFreturns the full name of the day of the week for a date
@DOWIreturns the day of the week for a date as a number
@DOWIStests whether a date matches specified days of the week
@DOYreturns the day of the year for a date
@EASTERreturns the date of Easter for the specified year
@FILESTAMPreturns a file’s date and time stamps, correctly localized
@HOLIDAYreturns the date of a specific day of the week within a month
@IDOWreturns the abbreviated local name for the day of the week for a date
@IDOWFreturns the full local name for the day of the week for a date
@INLIEUsubstitutes a weekday for a weekend date
@INRANGEtests whether a date falls within a range
@ISDATEreturns 1 if its argument is a valid date, 0 otherwise
@ISHOLIDAYreturns 1 if its argument is an annual holiday, 0 otherwise
@ISODOWIreturns the day of the week for a date as an integer, per ISO 8601
@ISOWEEKreturns the ISO 8601 week number for a date
@ISOWYEARreturns the ISO 8601 week-numbering year for a date
@ISTIMEreturns 1 if its argument is a valid time, 0 otherwise
@JULIANconverts a date into a day number
@LEAPreturn 1 if a year is leap, 0 if common
@LOCALDATETIMEconverts a UTC date and time to the local time zone
@MAKEAGEconverts a date and time into an NTFS file age
@MAKEDATEconverts an MS-DOS day number to a date
@MONTHreturns the month number for a date
@MONTHLENreturns the number of days in a given month
@MONTHNAMEreturns the name of a month
@NEXTDATEreturns the next date matching a specified month and day
@NEXTDOWreturns the next day matching a specified day of the week
@ORDreturns a number with an English ordinal suffix
@PICKDATEallows the user to select a date from a popup calendar
@ROMANconverts an integer to a Roman numeral, or vice versa
@TIMEDIFFsubtracts one time from another and returns the difference
@TIMEFMTformats a time for display
@TIMEPARTSparses a time and indicates which parts were specified
@TIMEPLUSadds an offset to a time
@TIMETODECconverts a time into a decimal fraction of a day
@USECONDSconverts a date and time to seconds past the Unix epoch
@USWEEKreturns a week number for a given date
@UTCDATETIMEconverts a local date and time to UTC
@UXTODATETIMEconverts a Unix time stamp to a date and time
@YEARreturns the year for a date