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.
The Excel PV function calculates the present value (or original amount) of a loan or investment.
The Excel RATE function calculates the interest rate per period for a loan or investment.