Excel Formulas

Returns the serial number that represents the date that is the indicated number of months before or after a specified date

Returns the serial number for the last day of the month that is the indicated number of months before or after start_date

Converts a serial number to an hour

Converts a serial number to a minute

Converts a serial number to a month

Returns the number of whole working days between two dates

Returns the serial number of the current date and time

Converts a serial number to a second

Returns the serial number of a particular time

Converts a time in the form of text to a serial number

Returns the serial number of today's date

Converts a serial number to a day of the week

Returns the week number of a specific date

Returns a date a specified number of workdays before or after a date

Converts a serial number to a year

Returns the accrued interest for a security that pays periodic interest

Returns the accrued interest for a security that pays interest at maturity

Returns the depreciation for each accounting period using depreciation coefficient

Returns the depreciation for each accounting period

Returns the number of days from the beginning of the coupon period to the settlement date