![]() ![]() Returns the number of days from the settlement date to the next coupon date Returns the number of days in the coupon period that contains the settlement date Returns the number of days from the beginning of the coupon period to the settlement date Returns the accrued interest for a security that pays interest at maturity Returns the accrued interest for a security that pays periodic interest Returns the serial number of the date before or after a specific number of workdays using parameters to indicate which and how many days are weekend days Returns the serial number of the date before or after a specified number of workdays ![]() ![]() Returns the serial number of today’s dateĬonverts a serial number to a day of the weekĬonverts a serial number to a number representing where the week falls numerically within a year Returns the serial number of the current date and time Returns the number of who workdays between two dates using parameters to indicate which and how many days are weekend days Returns the number of whole workdays between two dates Returns the serial number of the last day of the month Returns the serial number of the date that is the indicated number of months before or after the start date Returns the number of days between two dates Returns the serial number of a particular dateĬalculates the number of days, months or years between two datesĬonverts a data in the form of text to a serial numberĬonverts a serial number to a day of the month ![]() The categories are DATE and TIME functions, FINANCIAL functions, LOGICAL functions, LOOKUP and REFERENCE functions, MATHEMATICAL functions, STATISTICAL functions and TEXT functions. This list will help to give you ideas of how to combine many different functions to create more effective spreadsheets. The most common types of functions that most Excel users will implement are mathematical, logical and lookups, but there are some very powerful functions that you may not have come across before. These functions have been categorised to for ease of use. Here is a list of over 100 Excel functions and formulas to help you create better spreadsheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |