| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | This function can be used to calculate maturity dates or due dates that fall on the same day on the month as the date of issue. |
| | | If "start_date" is not a valid date, then #NUM! is returned. |
| | | If "start_date" plus "months" yields an invalid date, then #NUM! is returned. |
| | | If "months" is not an integer, it is truncated. |
| | | If "months" > 0, then a date in the future is returned. |
| | | If "months" < 0, then a date in the past is returned. |
| | | If "months" = 0, then the end of the "start_date" month is returned. |
| | | If "months" is left blank, then #N/A is returned. |
| | | If no arguments are submitted, then #NA! is returned |
| | | You should try and enter your dates using the DATE() function. |
| | | You can use the TEXT() function to return a number with a particular format. |
| | | You can use the DATEVALUE() function to return the serial number representing a date in a text format. |
