Formating Dates

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

LovingLife28

I need to update a list of dates to show all days as 01. For example, where
date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any
guidance!
 
I need to update a list of dates to show all days as 01. For example, where
date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any
guidance!
Click to expand...


If you want to convert the dates to the first of the month, then, with your
date in A1:

=A1-DAY(A1)+1

If you want to leave the date as is, but merely have display as mm/01/yyyy

Then custom format: mm"/01/"yyyy

--ron
 
With the Analysis ToolPak add-in installed:
=EOMONTH(A2,-1)+1

W/o add-in:
=DATE(YEAR(A2),MONTH(A2),1)
 
With dates in column A, In B1 enter:

=DATE(YEAR(A1),MONTH(A1),1) and copy down
 
Back
Top