###### Excel YEAR function

The Excel YEAR function returns the year, a number between 1900 and 9999. The YEAR function is an Excel date and time function.

###### Excel MONTH 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.

###### Excel DAY 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.

###### Excel DATE 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.

###### Excel NPER function

The Excel NPER function calculates the number of periods, or amount of time, needed to payoff a loan or reach an investment objective.

###### Excel IRR function

The Excel IRR function calculates the internal rate of return of an investment based upon a series of cashflows

###### Excel NPV function

The Excel NPV function calculates the net present value of an investment based upon a discount rate and a series of cashflows.

###### Excel FV function

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.

###### Excel PV function

The Excel PV function calculates the present value (or original amount) of a loan or investment.

###### Excel RATE function

The Excel RATE function calculates the interest rate per period for a loan or investment.

End of content