Make all dates display 01 as the day

  • Thread starter Thread starter LovingLife28
  • Start date Start date
L

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!
 
First date in A1 (03/25/2009)
In B1 =DATE(YEAR(A1),MONTH(A1),1) will display 01/05/2009
best wishes
 
LovingLife28 said:
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!
Click to expand...


=A1-DAY(A1)+1
 
Back
Top