Hi Alex

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

HTH. Best wishes Harald

"Alex" skrev i melding
...
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