The Excel ISERROR function determines whether a value is an error and returns TRUE if an error or FALSE if not an error.
The Excel IFERROR function returns a specified value if the expression is an error. The IFERROR function is an Excel logical function.
The Excel YEAR function returns the year, a number between 1900 and 9999. The YEAR function is an Excel date and time function.
The Excel MONTH function returns the month of the year, a number between 1 and 12. The MONTH function is an Excel date and time function.
The Excel DAY function returns the day of the month, a number between 1 and 31.The DAY function is an Excel date and time function.
The Excel DATE function returns the number that represents a date in Excel. If the cell number format is set to a date type then the number will be shown as a date. The DATE function is an Excel date and time function.
The Excel NPER function calculates the number of periods, or amount of time, needed to payoff a loan or reach an investment objective.
The Excel IRR function calculates the internal rate of return of an investment based upon a series of cashflows
The Excel NPV function calculates the net present value of an investment based upon a discount rate and a series of cashflows.
The Excel FV function calculates the future value (e.g., the remaining amount) of a loan or investment at a point in time in the future.