Prev: Change authentication in 2007?
Next: Preview Excel 2007 files in Outlook from SharePoint
From: LovingLife28 on 6 May 2010 15:12
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
From: Ron Rosenfeld on 6 May 2010 15:20
On Thu, 6 May 2010 12:12:01 -0700, LovingLife28
<LovingLife28(a)discussions.microsoft.com> 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
From: Luke M on 6 May 2010 15:20
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" <LovingLife28(a)discussions.microsoft.com> wrote in message
news:55FD4475-18ED-4479-92DE-509B09B84D35(a)microsoft.com...
>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


From: Gary''s Student on 6 May 2010 15:21
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
From: LovingLife28 on 6 May 2010 16:35
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
 | 
Pages: 1
Prev: Change authentication in 2007?
Next: Preview Excel 2007 files in Outlook from SharePoint