I'm running ... Office 2007 Pro.

Try this...

=TEXT(EDATE(B5,6),"mmmm")

--
Biff
Microsoft Excel MVP


"Jim Peterson" wrote in message
...
Hi everyone and thanks for any help you might have. It seems like one of
you
always has the answer I need!

I'm running XP Pro and Office 2007 Pro.

In my spreadsheet I enter an actual date in cell B5. I need a formula for
cell A6 that will return the month only six months in the future.

For example, the date entered in B5 is 02/15/10. The answer in A6 needs to
be August, not August 15, just August.

If I use B5+180, I get 08/14/10. It doesn't matter on what day of the
month
the initial activity occurs, the answer has to be the sixth month after
the
initial month of occurance. (Sorry if this is confusing, I'm trying to
make
it clear.)

The problem with B5+180 is when B5 is the last day of the month, 180 days
later may fall in the start of the seventh month, and the answer has to be
the sixth month.

Thanks again for any help you can offer and I look forward to hearing from
you.

Jim