On 3/16/2010 8:18 PM, Jim wrote:
Hello,

In A1 I have the date 3/10/10.

In B1 I would like to insert a formula that will show the Date 4/1/10.

Basically, I would like a formula that will show the first of the next month
no matter what date is shown in A1.

Thanks for the help.

One of a few ideas:

=EOMONTH(A1,0)+1

= = = = = = =
HTH :)
Dana DeLouis