ExcelBanter - Adding a month

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding a month (https://www.excelbanter.com/excel-worksheet-functions/9044-adding-month.html)

Alex

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

Harald Staff

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

Alex

Thanks

Alex

"Harald Staff" wrote in message
...
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

All times are GMT +1. The time now is 07:09 PM.