On Tue, 1 Mar 2005 09:19:07 -0800, "JJalomo"
wrote:

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.


=c4-day(c4)+1


--ron