I am trying to set up a formule that will show show the the date of the first
of each month from a date from another cell. For example.

In cell a1 I enter and arbitrary date, let say 7/1/06. In cell C1, the
formula calculates the day left in the month and shows the first date of the
next month, for example 8/1/06. then in cell D1, the formula calculates the
date of the next month, for example 9/1/06.

Is there such a formala?