FinishDCF | ||||||||
Data Type: Date (Optional) | ||||||||
A date number in Excels own system of date numbers, or can also be a decimal year (eg 2001.5, 2002.75). If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). | ||||||||
This date and the corresponding Start date over-ride any other start and finish dates in the function, so that you can define a sub-range of cashflows over which you want to do the DCF calculation. If omitted all cashflows of the function are included. | ||||||||
Example: 2020 |