I've looked and can't seem to determine somethat should be simple. I've got
a date 3/31/2006 and I want to add 6 months so the resulting answer should
be 9/30/2006. I know I can use Month on the original date and get 3 then
add the number of months I want to get 9 (september), but how do I get it to
give me the last day of the month given March 31, 2000 plus 6 months should
be Sept. 30, 2006.

Also, what if I want to add 18 months to 3/31/2006... I'd want the answer to
be 9/30/2007.

Thanks!

PS - I'm unsing Excel 2003