=EOMONTH(start_date,months)


On Oct 24, 8:29*pm, JAD wrote:
I have a worksheet that contains (3) columns of date information; Start Date,
Number of Months, End Date. To calculate the End Date, I am using the EDATE
function that is not outputting the answer I am expecting. As an example of
what EDATE reports, here are some examples.
* * * * * * * * * * * * *Start Date * * * * * * # of Months * * * * * * End
Date
Example 1 * * * *Nov-10 * * * * * * * * * * (16) * * * * * * * * * * * May-09
Example 2 * * * *Nov-10 * * * * * * * * * * (12) * * * * * * * * * * * Nov-09
Example 3 * * * *Nov-10 * * * * * * * * * * (18) * * * * * * * * * * * May-10
Example 4 * * * *Nov-10 * * * * * * * * * * (18) * * * * * * * * * * * Nov-10

Can anyone tell me why EDATE is reporting incorrect data and how I might be
able to fix it? Your response would be appreciated. Thank You, JAD