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.
0 Comments
December 26, 2020
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.
December 26, 2020
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.
December 26, 2020
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.
December 26, 2020
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.
December 20, 2020
Excel IRR function
The Excel IRR function calculates the internal rate of return of an investment based upon a series of cashflows
December 19, 2020
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.
December 19, 2020
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.
December 6, 2020
Excel PV function
The Excel PV function calculates the present value (or original amount) of a loan or investment.
November 16, 2020
Excel RATE function
The Excel RATE function calculates the interest rate per period for a loan or investment.
November 16, 2020