First date in A1 (03/25/2009)
In B1 =DATE(YEAR(A1),MONTH(A1),1) will display 01/05/2009
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"LovingLife28" wrote in message
...
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!
--
LL28