On Oct 31, 1:16*pm, Paul wrote:
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.

With Excel 2007 or Analysis Toolpak:

=EOMONTH(A1,0)+1