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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Jeff" wrote in message
...
Hi, is there an Excel function where we could round-up the date to 1st day
of
the following month. For example

Cell A1 is 2006/08/25. I need cell B1 to be tabulated automatically to be
2006/09/01.
If cell A2 is 2006/11/11, cell B2 will be 2006/12/01.

Thanks for you support.

Jeff