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!
--
LL28

On Thu, 6 May 2010 12:12:01 -0700, LovingLife28
wrote:

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!


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)

--
Best Regards,

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

With dates in column A, In B1 enter:

=DATE(YEAR(A1),MONTH(A1),1) and copy down
--
Gary''s Student - gsnu201002


"LovingLife28" wrote:

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!
--
LL28

Perfect! Thank so much!
--
LL28


"LovingLife28" wrote:

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!
--
LL28