Adding a month

Hi, I have a cell A1 which is formatted mmm-yy. I want B1 to be Ai plus
the next month and so on. How do I format that please

Alex

Hi Alex

=DATE(YEAR(A1),MONTH(A1)+1,1)

HTH. Best wishes Harald

"Alex" <aph@nospam_misnet_.co._.uk> skrev i melding
news:eQV7xgB%[email protected]...
> Hi, I have a cell A1 which is formatted mmm-yy. I want B1 to be Ai plus
> the next month and so on. How do I format that please
>
> Alex
>
>

Thanks

Alex

"Harald Staff" <[email protected]> wrote in message
news:OzioFnB%[email protected]...
> Hi Alex
>
> =DATE(YEAR(A1),MONTH(A1)+1,1)
>
> HTH. Best wishes Harald
>
> "Alex" <aph@nospam_misnet_.co._.uk> skrev i melding
> news:eQV7xgB%[email protected]...
>> Hi, I have a cell A1 which is formatted mmm-yy. I want B1 to be Ai plus
>> the next month and so on. How do I format that please
>>
>> Alex
>>
>>
>
>