=SUM(C4,-DAY(C4),1)

HTH
Jason
Atlanta, GA

-----Original Message-----
I need a formula or function which will return the first
of the month. For
example, if Cell c4 contains 2/15/05, i need to return
2/01/05 in cell d4.

Cell c4 can contain any date.


.