1st of Next Month

Beth · Feb 14, 2006

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 · Feb 14, 2006

Hi Beth,

Try:

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

Beth · Feb 14, 2006

Thanks Norman, this has worked

Norman Jones said:
Hi Beth,

Try:

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