Adding a month

Alex · Jan 11, 2005

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

Harald Staff · Jan 11, 2005

Hi Alex

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

HTH. Best wishes Harald

Alex · Jan 11, 2005

Thanks

Alex

Harald Staff said:
Hi Alex

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

HTH. Best wishes Harald