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

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

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