First day and Last day of the month to display automatically

[Guest]

If I input the date 11-Apr-2007 in Cell B1. Then the Cell A1 should
automatically display the first day of the month(1-Apr-2007) and the Cell C1
should automatically display the last day of the month(30-Apr-2007).

If i input 12-May-2007 in B1, then A1 needs to be 1-May-2007 and C1 needs to
be 31-May-2007.

Any way to get this?

 

[Bob Phillips]

=B1-DAY(B1)+1

=DATE(YEAR(B1),MONTH(B1)+1,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)