Archive

Returns the current date and time in datetime format.

Returns the month as a number from 1 (January) to 12 (December).

Returns the minute as a number from 0 to 59, given a date and time value.

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).

Returns the date in datetime format of the last day of the month, before or after a specified number of months. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

Returns the date that is the indicated number of months before or after the start date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

Returns the day of the month, a number from 1 to 31.

Converts a date in text format to a date in datetime format.

Returns the count of interval boundaries crossed between two dates.

Returns the specified date in datetime format.