Make all dates display 01 as the day

[LovingLife28]

I have a list of dates with various numbers listed as the day (03/25/2009,
04/05/2010, etc.) I need a formula to change all of the dates to display 01
as the day (03/01/2009, 04/01/2010, etc). Thanks!

 

[Bernard Liengme]

First date in A1 (03/25/2009)
In B1 =DATE(YEAR(A1),MONTH(A1),1) will display 01/05/2009
best wishes

 

[Glenn]

I have a list of dates with various numbers listed as the day (03/25/2009,
04/05/2010, etc.) I need a formula to change all of the dates to display 01
as the day (03/01/2009, 04/01/2010, etc). Thanks!

=A1-DAY(A1)+1