greg wrote:
can you add months to a date?
So for example you have a date. any date. like 5/20/2010
Then I want to add 6 months to the date. Then get 11/20/2010
Is there a way to do this in vba/excel?

thanks

It depends on what you mean by "month".

For example, you have a date like "8/31/yyyy". Add 6 months. February...31?