One way:

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"Paul" wrote in message
...
I have 2 columns. In the first column I would have dates and I want the
next
column to project teh first day of the upcoming month based on the date in
column A. Anyway way to do that as a function?

Thank you in advance for any assistance.