ExcelBanter - 1st of Next Month

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - 1st of Next Month (https://www.excelbanter.com/excel-discussion-misc-queries/71481-1st-next-month.html)

Beth

1st of Next Month

Hello,

I have got a column of dates in Excel.

I want another column showing the 1st date of the following month.

Please can anyone let me know if this is possible.

Thanks,
Beth

Norman Jones

1st of Next Month

Hi Beth,

Try:

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

---
Regards,
Norman

"Beth" wrote in message
...
Hello,

I have got a column of dates in Excel.

I want another column showing the 1st date of the following month.

Please can anyone let me know if this is possible.

Thanks,
Beth

Beth

1st of Next Month

Thanks Norman, this has worked

"Norman Jones" wrote:

Hi Beth,

Try:

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

---
Regards,
Norman

"Beth" wrote in message
...
Hello,

I have got a column of dates in Excel.

I want another column showing the 1st date of the following month.

Please can anyone let me know if this is possible.

Thanks,
Beth

All times are GMT +1. The time now is 07:28 AM.